Oracle强制sql走索引

Oracle强制sql走索引

今天我们来说说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 +