SELECT ID
FROM (SELECT ID
FROM TBL_AUDIT_QUEUE
WHERE IS_PROCESSED = 'N'
ORDER BY QUEUE_DATE)
WHERE ROWNUM <= :2
SELECT STATEMENT, GOAL = CHOOSE Cost=12931 Cardinality=153313 Bytes=11805101
COUNT STOPKEY
VIEW Object owner=EBAUDIT Cost=12931 Cardinality=153313 Bytes=11805101
SORT ORDER BY STOPKEY Cost=12931 Cardinality=153313 Bytes=6745772
TABLE ACCESS FULL Object owner=EBAUDIT Object name=TBL_AUDIT_QUEUE Cost=11763 Cardinality=153313 Bytes=6745772
SQL> select count(*) from TBL_AUDIT_QUEUE;
COUNT(*)
----------
2287526
在IS_PROCESSED列建位图索引可以提高效率吗？
FROM (SELECT ID
FROM TBL_AUDIT_QUEUE
WHERE IS_PROCESSED = 'N'
ORDER BY QUEUE_DATE)
WHERE ROWNUM <= :2
SELECT STATEMENT, GOAL = CHOOSE Cost=12931 Cardinality=153313 Bytes=11805101
COUNT STOPKEY
VIEW Object owner=EBAUDIT Cost=12931 Cardinality=153313 Bytes=11805101
SORT ORDER BY STOPKEY Cost=12931 Cardinality=153313 Bytes=6745772
TABLE ACCESS FULL Object owner=EBAUDIT Object name=TBL_AUDIT_QUEUE Cost=11763 Cardinality=153313 Bytes=6745772
SQL> select count(*) from TBL_AUDIT_QUEUE;
COUNT(*)
----------
2287526
在IS_PROCESSED列建位图索引可以提高效率吗？
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9375/viewspace-555093/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
这条语句有没有问题？
下一篇：
io问题，高手请进
请登录后发表评论
登录
全部评论
