Oracle函数索引与强制走索引

1.函数索引

在create_date 中加入to_char 函数索引

CREATE INDEX UCMDATA.IX_UCM_FUNCTION_CRE_DATE ON UCMDATA.UCM_MSG_INFO (to_char(created_date ,'yyyy-mm-dd')) INITRANS 16;

 

2.强制走索引

INDEX(表别名 索引名称)

例子：这个是走3个强制索引的

select/*+
INDEX(pa IDX_PAGREE_1)
INDEX(pi IDX_PITEM_5)
INDEX(pd IDX_PRODUCTS_3)
*/ * 
from table1 c,
table2 pa,
table3 pi,
table4 pd
where pa.customerid = c.customerid
and pi.purchaseagreementid = pa.id
and pi.productid = pd.id
and pd.statusid=3601;