oracle 中sql语句怎么加多个强制索引
最新回答
雨后初见彩虹
2026-10-23 00:38:02
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;
轮回亦思伊人
2026-06-20 21:29:56
这个是强制16进程并行。强制索引格式都是 /*+ */
你刚好出现
2026-05-16 02:02:50
没事别惹我
2026-08-18 13:25:34
热门标签
