<pre name="code" class="sql">SQL> create table test as select * from dba_objects;
Table created.
select * from test where object_id=10 and OWNER='SYS';
SQL> select count(*) from test where object_id=10;
COUNT(*)
----------
1
SQL> select count(*) from test;
COUNT(*)
----------
74443
模拟插入object_id=10 and OWNER='SYS'的记录
SQL> select object_id,owner,count(*) from test2 group by object_id,owner having object_id=10;
OBJECT_ID OWNER COUNT(*)
---------- ------------------------------ ----------
10 TEST 72636
10 SYS 10003
SQL> select count(*) from test2;
TABLE ACCESS BY INDEX ROWID前面的星号
最新推荐文章于 2024-07-24 04:12:13 发布
本文通过一个SQL查询示例,展示了当`TABLE ACCESS BY INDEX ROWID`前有星号时,表示索引扫描后需要在表上进行额外的过滤操作。通过创建合适的组合索引,可以显著减少回表操作,提高查询效率。
摘要由CSDN通过智能技术生成