--1719
SESSION_ID 1141
SQL_ID drpk7cccd9xhm
MACHINE WORKGROUP\TLCB-PC
BLOCKING_SESSION
SAMPLE_TIME 10-4月 -19 07.50.01.154 下午
MODULE PL/SQL Developer
PROGRAM plsqldev.exe
EVENT db file sequential read
P1 4
P1TEXT file#
P2 190469
P2TEXT block#
P3 1
P3TEXT blocks
SQL_TEXT select count(*) from p800 where owner='SCOTT'
SQL> select owner,segment_name,segment_type,partition_name from dba_extents where file_id=4 and 190469 between block_id and block_id+blocks-1;
OWNER SEGMENT_NAME SEGMENT_TYPE PARTITION_NAME
---------- ------------------------------ ------------------------------ ------------------------------------------------------------------------------------------
TEST P800_IDX2 INDEX
SQL> explain plan
index range scan 单块读
最新推荐文章于 2021-04-12 09:21:49 发布
本文详细探讨了Oracle数据库中的index range scan操作,解释了它如何在单块读中提高查询性能。通过理解索引范围扫描的工作原理,读者将能够更好地优化数据库查询并提升系统整体效率。
摘要由CSDN通过智能技术生成