How to specify the use of index when querying or deleting ORACLE

-
You can specify how to use the index when querying. ­

­

SELECT /*+ index(TB_ALIAS IX_G_COST3) */­

TB_ALIAS.*­

FROM g_Cost TB_ALIAS­

WHERE Item_Two = 0­

AND Flight_Date >= To_Date('20061201', 'YYYYMMDD')­

AND Flight_Date <= To_Date('20061231', 'YYYYMMDD');&shy;

&shy;

You can also specify how to use the index when deleting. &shy;

&shy;

DELETE /*+ index(TB_ALIAS IX_G_COST1) */&shy;

FROM g_Cost TB_ALIAS&shy;

WHERE ITEM_NAME = 'Hourly fee';&shy;

&shy;

IX_G_COST1, IX_G_COST3 are both indexes of table G_COST.