今天我们来说说Oracle强制sql走索引:
例: SELECT /+index(t pk_emp)/* FROM EMP T;
也可通过view强制使用索引:
CREATE OR REPLACE VIEW V_RES_CBA AS
SELECT /*+INDEX(SEG IDX_T_RES_ALLOSEG_ALLOID)*/
ALLO.ALLOID AS RESID,
NULL AS AWB,
ALLO.ALLOTMENT AS ALLO_ID,
DAYS.FDATE +