explain plan for SELECT tcnt,
rn,
CustomerID,
CustomerName,
CustomerType,
CertType,
CertID,
MFCustomerID,
MCCustomerID,
ManageOrgName,
ManageUserName,
ManageUserID,
Private,
Isresure,
Balance
FROM (SELECT COUNT(1) OVER() AS tcnt,
ROWNUM AS rn,
O.CustomerID,
O.CustomerName,
O.CustomerType,
O.CertType,
O.CertID,
O.MFCustomerID,
O.MCCustomerID,
GETMANAGEUSERID(O.CustomerID) AS ManageUserID,
GETMANAGEORGNAME(O.CustomerID) AS ManageOrgName,
GETMANAGEUSERNAME(O.CustomerID) AS ManageUserName,
O.Priv
FILTER 索引扫描多次
最新推荐文章于 2023-01-08 13:47:57 发布
本文详细探讨了数据库中的FILTER索引扫描,解释了如何在查询优化中多次使用此技术以提高性能。通过实例分析,展示了FILTER在不同场景下的应用,揭示了其对数据库查询效率的影响。
摘要由CSDN通过智能技术生成