Question

oracle 中sql语句怎么加多个强制索引

Answer 1

使用hint技术,表别名+索引名
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;

Answer 2

SELECT /*+PARALLEL (16)*/ A.* 1 FROM A;
这个是强制16进程并行。强制索引格式都是 /*+ */

Answer 3

xiexie

Answer 4

谢谢 学习了 呵呵