select /*+index(w idex_ic_week_report_item_date)*/
substr(w.F_WORK_DATE, 1, 6) f_date
FROM ic_week_report_item
指定索引/*+INDEX(TABLE INDEX_NAME)*/等优化Oracle查询效率
最新推荐文章于 2024-06-24 09:01:11 发布
select /*+index(w idex_ic_week_report_item_date)*/
substr(w.F_WORK_DATE, 1, 6) f_date
FROM ic_week_report_item