ORACLE查詢或刪除時指定使用索引的寫法­

    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;
    刪除時也可以指定使用索引的寫法。&shy;
    &shy;
    DELETE /*+ index(TB_ALIAS IX_G_COST1) */&shy;
    FROM g_Cost TB_ALIAS&shy;
    WHERE ITEM_NAME = '小時費';&shy;
    &shy;
    IX_G_COST1，IX_G_COST3都是表G_COST的索引。