常见索引扫描浅析（三）：INDEX FULL SCAN
作者 ：OoNiceDream【转载时请务必以超链接形式标明文章原始出处和作者信息】
链接：http://www.dbaroad.me/archives/2009/06/index_full_scan.html
链接：http://www.dbaroad.me/archives/2009/06/index_full_scan.html
查看执行计划：
SQL> set autot trace exp SQL> select id from test order by id; Execution Plan ---------------------------------------------------------- Plan hash value: 129968086 -------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 115K| 565K| 258 (1)| 00:00:37 | | 1 | INDEX FULL SCAN | IND_TEST_ID | 115K| 565K| 258 (1)| 00:00:37 | --------------------------------------------------------------------------------
通过10046观察BLOCK读取顺序：
SQL> alter system flush BUFFER_CACHE; System altered. SQL> oradebug setmypid Statement processed. SQL> oradebug event 10046 trace name context forever,level 12; Statement processed. SQL> select id from test order by id; $ cat emrep_ora_10081.trc | grep "db file s" WAIT #3: nam='db file sequential read' ela= 944 file#=1 block#=68986 blocks=1 obj#=93996 tim=26727822148540 WAIT #3: nam='db file sequential read' ela= 82 file#=1 block#=68987 blocks=1 obj#=93996 tim=26727822148703 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=68988 blocks=1 obj#=93996 tim=26727822169994 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=68989 blocks=1 obj#=93996 tim=26727822189727 WAIT #3: nam='db file sequential read' ela= 24 file#=1 block#=68990 blocks=1 obj#=93996 tim=26727822209260 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=68991 blocks=1 obj#=93996 tim=26727822229102 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=68992 blocks=1 obj#=93996 tim=26727822248578 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69297 blocks=1 obj#=93996 tim=26727822268016 WAIT #3: nam='db file sequential read' ela= 72 file#=1 block#=69298 blocks=1 obj#=93996 tim=26727822287909 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69299 blocks=1 obj#=93996 tim=26727822307466 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69300 blocks=1 obj#=93996 tim=26727822327075 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69301 blocks=1 obj#=93996 tim=26727822342087 WAIT #3: nam='db file sequential read' ela= 17 file#=1 block#=69302 blocks=1 obj#=93996 tim=26727822356352 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69303 blocks=1 obj#=93996 tim=26727822374262 WAIT #3: nam='db file sequential read' ela= 17 file#=1 block#=69304 blocks=1 obj#=93996 tim=26727822388493 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=69337 blocks=1 obj#=93996 tim=26727822402731 WAIT #3: nam='db file sequential read' ela= 66 file#=1 block#=69338 blocks=1 obj#=93996 tim=26727822416861 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69339 blocks=1 obj#=93996 tim=26727822430838 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69340 blocks=1 obj#=93996 tim=26727822444291 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69341 blocks=1 obj#=93996 tim=26727822579990 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69342 blocks=1 obj#=93996 tim=26727822594175 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69343 blocks=1 obj#=93996 tim=26727822608461 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69344 blocks=1 obj#=93996 tim=26727822622671 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69345 blocks=1 obj#=93996 tim=26727822636267 WAIT #3: nam='db file sequential read' ela= 33 file#=1 block#=69346 blocks=1 obj#=93996 tim=26727822815825 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69347 blocks=1 obj#=93996 tim=26727822830004 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69348 blocks=1 obj#=93996 tim=26727822844132 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69349 blocks=1 obj#=93996 tim=26727822858812 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69350 blocks=1 obj#=93996 tim=26727822872365 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69351 blocks=1 obj#=93996 tim=26727823039370 WAIT #3: nam='db file sequential read' ela= 40 file#=1 block#=69352 blocks=1 obj#=93996 tim=26727823053855 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=69353 blocks=1 obj#=93996 tim=26727823067988 WAIT #3: nam='db file sequential read' ela= 37 file#=1 block#=69354 blocks=1 obj#=93996 tim=26727823082136 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=69355 blocks=1 obj#=93996 tim=26727823095327 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69356 blocks=1 obj#=93996 tim=26727823312623 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69357 blocks=1 obj#=93996 tim=26727823326358 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69358 blocks=1 obj#=93996 tim=26727823340601 WAIT #3: nam='db file sequential read' ela= 22 file#=1 block#=69359 blocks=1 obj#=93996 tim=26727823354404 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=69360 blocks=1 obj#=93996 tim=26727823457965 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69361 blocks=1 obj#=93996 tim=26727823472086 WAIT #3: nam='db file sequential read' ela= 29 file#=1 block#=69362 blocks=1 obj#=93996 tim=26727823487945 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69363 blocks=1 obj#=93996 tim=26727823506862 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69364 blocks=1 obj#=93996 tim=26727823526641 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69365 blocks=1 obj#=93996 tim=26727823546381 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69366 blocks=1 obj#=93996 tim=26727823564721 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69367 blocks=1 obj#=93996 tim=26727823582914 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69368 blocks=1 obj#=93996 tim=26727823601084 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69369 blocks=1 obj#=93996 tim=26727823619549 WAIT #3: nam='db file sequential read' ela= 28 file#=1 block#=69370 blocks=1 obj#=93996 tim=26727823638036 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69371 blocks=1 obj#=93996 tim=26727823656632 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69372 blocks=1 obj#=93996 tim=26727823674692 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69373 blocks=1 obj#=93996 tim=26727823692945 WAIT #3: nam='db file sequential read' ela= 17 file#=1 block#=69374 blocks=1 obj#=93996 tim=26727823711343 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69375 blocks=1 obj#=93996 tim=26727823728881 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69376 blocks=1 obj#=93996 tim=26727823747236 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69377 blocks=1 obj#=93996 tim=26727823765482 WAIT #3: nam='db file sequential read' ela= 31 file#=1 block#=69378 blocks=1 obj#=93996 tim=26727823784091 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69379 blocks=1 obj#=93996 tim=26727823802602 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69380 blocks=1 obj#=93996 tim=26727823821251 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69381 blocks=1 obj#=93996 tim=26727823839642 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69382 blocks=1 obj#=93996 tim=26727823858036 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69383 blocks=1 obj#=93996 tim=26727823875706 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69384 blocks=1 obj#=93996 tim=26727823893900 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69513 blocks=1 obj#=93996 tim=26727823912442 WAIT #3: nam='db file sequential read' ela= 65 file#=1 block#=69514 blocks=1 obj#=93996 tim=26727823930933 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69515 blocks=1 obj#=93996 tim=26727823949305 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69516 blocks=1 obj#=93996 tim=26727823967847 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69517 blocks=1 obj#=93996 tim=26727823986238 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69518 blocks=1 obj#=93996 tim=26727824004788 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69519 blocks=1 obj#=93996 tim=26727824022300 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69520 blocks=1 obj#=93996 tim=26727824040004 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69521 blocks=1 obj#=93996 tim=26727824057622 WAIT #3: nam='db file sequential read' ela= 34 file#=1 block#=69522 blocks=1 obj#=93996 tim=26727824075204 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69523 blocks=1 obj#=93996 tim=26727824092693 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69524 blocks=1 obj#=93996 tim=26727824110272 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69525 blocks=1 obj#=93996 tim=26727824127889 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69526 blocks=1 obj#=93996 tim=26727824145109 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69527 blocks=1 obj#=93996 tim=26727824162805 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69528 blocks=1 obj#=93996 tim=26727824180360 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69529 blocks=1 obj#=93996 tim=26727824197815 WAIT #3: nam='db file sequential read' ela= 31 file#=1 block#=69530 blocks=1 obj#=93996 tim=26727824215249 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69531 blocks=1 obj#=93996 tim=26727824232876 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69532 blocks=1 obj#=93996 tim=26727824250427 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69533 blocks=1 obj#=93996 tim=26727824267301 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69534 blocks=1 obj#=93996 tim=26727824285106 WAIT #3: nam='db file sequential read' ela= 17 file#=1 block#=69535 blocks=1 obj#=93996 tim=26727824302825 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69536 blocks=1 obj#=93996 tim=26727824320627 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69537 blocks=1 obj#=93996 tim=26727824338276 WAIT #3: nam='db file sequential read' ela= 32 file#=1 block#=69538 blocks=1 obj#=93996 tim=26727824356094 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69539 blocks=1 obj#=93996 tim=26727824373783 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69540 blocks=1 obj#=93996 tim=26727824391476 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69541 blocks=1 obj#=93996 tim=26727824408710 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69542 blocks=1 obj#=93996 tim=26727824426425 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69543 blocks=1 obj#=93996 tim=26727824444014 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69544 blocks=1 obj#=93996 tim=26727824461719 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69545 blocks=1 obj#=93996 tim=26727824479380 WAIT #3: nam='db file sequential read' ela= 28 file#=1 block#=69546 blocks=1 obj#=93996 tim=26727824496949 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69547 blocks=1 obj#=93996 tim=26727824514640 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69548 blocks=1 obj#=93996 tim=26727824531831 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69549 blocks=1 obj#=93996 tim=26727824549712 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69550 blocks=1 obj#=93996 tim=26727824567466 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69551 blocks=1 obj#=93996 tim=26727824585156 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69552 blocks=1 obj#=93996 tim=26727824602771 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69553 blocks=1 obj#=93996 tim=26727824620447 WAIT #3: nam='db file sequential read' ela= 30 file#=1 block#=69554 blocks=1 obj#=93996 tim=26727824638156 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69555 blocks=1 obj#=93996 tim=26727824655906 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69556 blocks=1 obj#=93996 tim=26727824673154 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69557 blocks=1 obj#=93996 tim=26727824690910 WAIT #3: nam='db file sequential read' ela= 27 file#=1 block#=69558 blocks=1 obj#=93996 tim=26727824708758 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69559 blocks=1 obj#=93996 tim=26727824726468 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69560 blocks=1 obj#=93996 tim=26727824744223 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69561 blocks=1 obj#=93996 tim=26727824761948 WAIT #3: nam='db file sequential read' ela= 35 file#=1 block#=69562 blocks=1 obj#=93996 tim=26727824779584 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69563 blocks=1 obj#=93996 tim=26727824796779 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69564 blocks=1 obj#=93996 tim=26727824814438 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69565 blocks=1 obj#=93996 tim=26727824832063 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69566 blocks=1 obj#=93996 tim=26727824849635 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69567 blocks=1 obj#=93996 tim=26727824867259 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69568 blocks=1 obj#=93996 tim=26727824884936 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=72497 blocks=1 obj#=93996 tim=26727824902612 WAIT #3: nam='db file sequential read' ela= 66 file#=1 block#=72498 blocks=1 obj#=93996 tim=26727824920213 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=72499 blocks=1 obj#=93996 tim=26727824937244 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=72500 blocks=1 obj#=93996 tim=26727824954728 WAIT #3: nam='db file sequential read' ela= 43 file#=1 block#=72501 blocks=1 obj#=93996 tim=26727824974082 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=72502 blocks=1 obj#=93996 tim=26727824992205 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=72503 blocks=1 obj#=93996 tim=26727825010591 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=72504 blocks=1 obj#=93996 tim=26727825028841 WAIT #3: nam='db file sequential read' ela= 23 file#=1 block#=69641 blocks=1 obj#=93996 tim=26727825047178 WAIT #3: nam='db file sequential read' ela= 88 file#=1 block#=69642 blocks=1 obj#=93996 tim=26727825064780 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69643 blocks=1 obj#=93996 tim=26727825082927 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69644 blocks=1 obj#=93996 tim=26727825101260 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69645 blocks=1 obj#=93996 tim=26727825119365 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69646 blocks=1 obj#=93996 tim=26727825137598 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69647 blocks=1 obj#=93996 tim=26727825155508 WAIT #3: nam='db file sequential read' ela= 22 file#=1 block#=69648 blocks=1 obj#=93996 tim=26727825173698 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69649 blocks=1 obj#=93996 tim=26727825191943 WAIT #3: nam='db file sequential read' ela= 38 file#=1 block#=69650 blocks=1 obj#=93996 tim=26727825209639 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69651 blocks=1 obj#=93996 tim=26727825227677 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69652 blocks=1 obj#=93996 tim=26727825245810 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69653 blocks=1 obj#=93996 tim=26727825264084 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69654 blocks=1 obj#=93996 tim=26727825282040 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69655 blocks=1 obj#=93996 tim=26727825299978 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69656 blocks=1 obj#=93996 tim=26727825318338 WAIT #3: nam='db file sequential read' ela= 50 file#=1 block#=69657 blocks=1 obj#=93996 tim=26727825336538 WAIT #3: nam='db file sequential read' ela= 48 file#=1 block#=69658 blocks=1 obj#=93996 tim=26727825355073 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69659 blocks=1 obj#=93996 tim=26727825373727 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=69660 blocks=1 obj#=93996 tim=26727825392368 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69661 blocks=1 obj#=93996 tim=26727825410996 WAIT #3: nam='db file sequential read' ela= 24 file#=1 block#=69662 blocks=1 obj#=93996 tim=26727825429592 WAIT #3: nam='db file sequential read' ela= 22 file#=1 block#=69663 blocks=1 obj#=93996 tim=26727825448475 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69664 blocks=1 obj#=93996 tim=26727825467231 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69665 blocks=1 obj#=93996 tim=26727825485248 WAIT #3: nam='db file sequential read' ela= 41 file#=1 block#=69666 blocks=1 obj#=93996 tim=26727825503990 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69667 blocks=1 obj#=93996 tim=26727825522640 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69668 blocks=1 obj#=93996 tim=26727825541394 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69669 blocks=1 obj#=93996 tim=26727825559945 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69670 blocks=1 obj#=93996 tim=26727825578796 WAIT #3: nam='db file sequential read' ela= 38 file#=1 block#=69671 blocks=1 obj#=93996 tim=26727825597409 WAIT #3: nam='db file sequential read' ela= 22 file#=1 block#=69672 blocks=1 obj#=93996 tim=26727825615058 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=69673 blocks=1 obj#=93996 tim=26727825633627 WAIT #3: nam='db file sequential read' ela= 52 file#=1 block#=69674 blocks=1 obj#=93996 tim=26727825652149 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69675 blocks=1 obj#=93996 tim=26727825670587 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69676 blocks=1 obj#=93996 tim=26727825689346 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69677 blocks=1 obj#=93996 tim=26727825708132 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69678 blocks=1 obj#=93996 tim=26727825726776 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=69679 blocks=1 obj#=93996 tim=26727825745306 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69680 blocks=1 obj#=93996 tim=26727825758344 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69681 blocks=1 obj#=93996 tim=26727825771447 WAIT #3: nam='db file sequential read' ela= 36 file#=1 block#=69682 blocks=1 obj#=93996 tim=26727825784586 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69683 blocks=1 obj#=93996 tim=26727825797754 WAIT #3: nam='db file sequential read' ela= 22 file#=1 block#=69684 blocks=1 obj#=93996 tim=26727825813233 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69685 blocks=1 obj#=93996 tim=26727825827138 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69686 blocks=1 obj#=93996 tim=26727825842639 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=69687 blocks=1 obj#=93996 tim=26727825859313 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69688 blocks=1 obj#=93996 tim=26727825877046 WAIT #3: nam='db file sequential read' ela= 22 file#=1 block#=69689 blocks=1 obj#=93996 tim=26727825895813 WAIT #3: nam='db file sequential read' ela= 33 file#=1 block#=69690 blocks=1 obj#=93996 tim=26727825914601 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69691 blocks=1 obj#=93996 tim=26727825933495 WAIT #3: nam='db file sequential read' ela= 36 file#=1 block#=69692 blocks=1 obj#=93996 tim=26727825953311 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=69693 blocks=1 obj#=93996 tim=26727825971792 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=69694 blocks=1 obj#=93996 tim=26727825990271 WAIT #3: nam='db file sequential read' ela= 23 file#=1 block#=69695 blocks=1 obj#=93996 tim=26727826007977 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=69696 blocks=1 obj#=93996 tim=26727826026075 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69697 blocks=1 obj#=93996 tim=26727826044314 WAIT #3: nam='db file sequential read' ela= 43 file#=1 block#=69698 blocks=1 obj#=93996 tim=26727826062682 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69699 blocks=1 obj#=93996 tim=26727826081158 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69700 blocks=1 obj#=93996 tim=26727826099465 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69701 blocks=1 obj#=93996 tim=26727826117937 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69702 blocks=1 obj#=93996 tim=26727826135616 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69703 blocks=1 obj#=93996 tim=26727826153784 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69704 blocks=1 obj#=93996 tim=26727826172387 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69705 blocks=1 obj#=93996 tim=26727826190800 WAIT #3: nam='db file sequential read' ela= 34 file#=1 block#=69706 blocks=1 obj#=93996 tim=26727826209060 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69707 blocks=1 obj#=93996 tim=26727826227400 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69708 blocks=1 obj#=93996 tim=26727826245861 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69709 blocks=1 obj#=93996 tim=26727826264110 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69710 blocks=1 obj#=93996 tim=26727826282002 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69711 blocks=1 obj#=93996 tim=26727826300110 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69712 blocks=1 obj#=93996 tim=26727826317753 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69713 blocks=1 obj#=93996 tim=26727826335553 WAIT #3: nam='db file sequential read' ela= 34 file#=1 block#=69714 blocks=1 obj#=93996 tim=26727826353180 WAIT #3: nam='db file sequential read' ela= 65 file#=1 block#=69715 blocks=1 obj#=93996 tim=26727826371295 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69716 blocks=1 obj#=93996 tim=26727826389768 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69717 blocks=1 obj#=93996 tim=26727826407437 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69718 blocks=1 obj#=93996 tim=26727826425653 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69719 blocks=1 obj#=93996 tim=26727826444091 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69720 blocks=1 obj#=93996 tim=26727826462465 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69721 blocks=1 obj#=93996 tim=26727826480809 WAIT #3: nam='db file sequential read' ela= 32 file#=1 block#=69722 blocks=1 obj#=93996 tim=26727826499357 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69723 blocks=1 obj#=93996 tim=26727826517711 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69724 blocks=1 obj#=93996 tim=26727826536027 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69725 blocks=1 obj#=93996 tim=26727826553744 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69726 blocks=1 obj#=93996 tim=26727826571967 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69727 blocks=1 obj#=93996 tim=26727826590295 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69728 blocks=1 obj#=93996 tim=26727826608623 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69729 blocks=1 obj#=93996 tim=26727826626870 WAIT #3: nam='db file sequential read' ela= 31 file#=1 block#=69730 blocks=1 obj#=93996 tim=26727826644954 WAIT #3: nam='db file sequential read' ela= 17 file#=1 block#=69731 blocks=1 obj#=93996 tim=26727826663237 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69732 blocks=1 obj#=93996 tim=26727826680996 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69733 blocks=1 obj#=93996 tim=26727826699256 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69734 blocks=1 obj#=93996 tim=26727826717725 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69735 blocks=1 obj#=93996 tim=26727826736112 WAIT #3: nam='db file sequential read' ela= 17 file#=1 block#=69736 blocks=1 obj#=93996 tim=26727826754520 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69737 blocks=1 obj#=93996 tim=26727826772914 WAIT #3: nam='db file sequential read' ela= 33 file#=1 block#=69738 blocks=1 obj#=93996 tim=26727826790877 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69739 blocks=1 obj#=93996 tim=26727826809039 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69740 blocks=1 obj#=93996 tim=26727826826946 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69741 blocks=1 obj#=93996 tim=26727826845396 WAIT #3: nam='db file sequential read' ela= 22 file#=1 block#=69742 blocks=1 obj#=93996 tim=26727826863907 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69743 blocks=1 obj#=93996 tim=26727826882132 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69744 blocks=1 obj#=93996 tim=26727826900642 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69745 blocks=1 obj#=93996 tim=26727826919509 WAIT #3: nam='db file sequential read' ela= 34 file#=1 block#=69746 blocks=1 obj#=93996 tim=26727826937766 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69747 blocks=1 obj#=93996 tim=26727826955221 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69748 blocks=1 obj#=93996 tim=26727826973346 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69749 blocks=1 obj#=93996 tim=26727826991584 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69750 blocks=1 obj#=93996 tim=26727827010068 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69751 blocks=1 obj#=93996 tim=26727827028305 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69752 blocks=1 obj#=93996 tim=26727827046716 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69753 blocks=1 obj#=93996 tim=26727827065151 WAIT #3: nam='db file sequential read' ela= 36 file#=1 block#=69754 blocks=1 obj#=93996 tim=26727827083518 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69755 blocks=1 obj#=93996 tim=26727827101169 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69756 blocks=1 obj#=93996 tim=26727827119607 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69757 blocks=1 obj#=93996 tim=26727827138111 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69758 blocks=1 obj#=93996 tim=26727827156455 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69759 blocks=1 obj#=93996 tim=26727827174747 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69760 blocks=1 obj#=93996 tim=26727827192990 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69761 blocks=1 obj#=93996 tim=26727827211370 WAIT #3: nam='db file sequential read' ela= 32 file#=1 block#=69762 blocks=1 obj#=93996 tim=26727827229085 WAIT #3: nam='db file sequential read' ela= 19 file#=1 block#=69763 blocks=1 obj#=93996 tim=26727827247593 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69764 blocks=1 obj#=93996 tim=26727827266084 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69765 blocks=1 obj#=93996 tim=26727827284435 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69766 blocks=1 obj#=93996 tim=26727827302812 WAIT #3: nam='db file sequential read' ela= 20 file#=1 block#=69767 blocks=1 obj#=93996 tim=26727827321301 WAIT #3: nam='db file sequential read' ela= 18 file#=1 block#=69768 blocks=1 obj#=93996 tim=26727827339647 WAIT #3: nam='db file sequential read' ela= 21 file#=1 block#=69769 blocks=1 obj#=93996 tim=26727827358349 WAIT #3: nam='db file sequential read' ela= 33 file#=1 block#=69770 blocks=1 obj#=93996 tim=26727827376157 |
同样通过dbms_utility的data_block_address_block函数转换，可以与TREEDUMP中的叶子节点、分枝节点一一对应起来，抽取TREEDUMP头尾几个进行转换：
SQL> variable x number; SQL> exec :x :=4263290 PL/SQL procedure successfully completed. SQL> select :x, 2 dbms_utility.data_block_address_file(:x) file_id#, 3 dbms_utility.data_block_address_block(:x) block_id# 4 from dual; :X FILE_ID# BLOCK_ID# ---------- ---------- ---------- 4263290 1 68986 SQL> exec :x :=4263291 PL/SQL procedure successfully completed. SQL> / :X FILE_ID# BLOCK_ID# ---------- ---------- ---------- 4263291 1 68987 SQL> exec :x :=4263292 PL/SQL procedure successfully completed. SQL> / :X FILE_ID# BLOCK_ID# ---------- ---------- ---------- 4263292 1 68988 SQL> exec :x :=4264073 PL/SQL procedure successfully completed. SQL> / :X FILE_ID# BLOCK_ID# ---------- ---------- ---------- 4264073 1 69769 SQL> exec :x :=4264074 PL/SQL procedure successfully completed. SQL> / :X FILE_ID# BLOCK_ID# ---------- ---------- ---------- 4264074 1 69770 |
与TREEDUMP进行对应：
----- begin tree dump branch: 0x410d7a 4263290 (0: nrow: 256, level: 1) ##对应BLOCK：68986 leaf: 0x410d7b 4263291 (-1: nrow: 491 rrow: 491) ##对应BLOCK：68987 leaf: 0x410d7c 4263292 (0: nrow: 477 rrow: 477) ##对应BLOCK：68988 leaf: 0x410d7d 4263293 (1: nrow: 478 rrow: 478) leaf: 0x410d7e 4263294 (2: nrow: 477 rrow: 477) leaf: 0x410d7f 4263295 (3: nrow: 478 rrow: 478) leaf: 0x410d80 4263296 (4: nrow: 477 rrow: 477) leaf: 0x410eb1 4263601 (5: nrow: 477 rrow: 477) leaf: 0x410eb2 4263602 (6: nrow: 478 rrow: 478) leaf: 0x410eb3 4263603 (7: nrow: 477 rrow: 477) leaf: 0x410eb4 4263604 (8: nrow: 477 rrow: 477) leaf: 0x410eb5 4263605 (9: nrow: 478 rrow: 478) leaf: 0x410eb6 4263606 (10: nrow: 477 rrow: 477) leaf: 0x410eb7 4263607 (11: nrow: 478 rrow: 478) leaf: 0x410eb8 4263608 (12: nrow: 477 rrow: 477) leaf: 0x410ed9 4263641 (13: nrow: 477 rrow: 477) leaf: 0x410eda 4263642 (14: nrow: 478 rrow: 478) leaf: 0x410edb 4263643 (15: nrow: 477 rrow: 477) leaf: 0x410edc 4263644 (16: nrow: 478 rrow: 478) leaf: 0x410edd 4263645 (17: nrow: 477 rrow: 477) leaf: 0x410ede 4263646 (18: nrow: 477 rrow: 477) leaf: 0x410edf 4263647 (19: nrow: 478 rrow: 478) leaf: 0x410ee0 4263648 (20: nrow: 477 rrow: 477) leaf: 0x410ee1 4263649 (21: nrow: 477 rrow: 477) leaf: 0x410ee2 4263650 (22: nrow: 478 rrow: 478) leaf: 0x410ee3 4263651 (23: nrow: 477 rrow: 477) leaf: 0x410ee4 4263652 (24: nrow: 478 rrow: 478) leaf: 0x410ee5 4263653 (25: nrow: 477 rrow: 477) leaf: 0x410ee6 4263654 (26: nrow: 477 rrow: 477) leaf: 0x410ee7 4263655 (27: nrow: 478 rrow: 478) leaf: 0x410ee8 4263656 (28: nrow: 477 rrow: 477) leaf: 0x410ee9 4263657 (29: nrow: 478 rrow: 478) leaf: 0x410eea 4263658 (30: nrow: 477 rrow: 477) leaf: 0x410eeb 4263659 (31: nrow: 477 rrow: 477) leaf: 0x410eec 4263660 (32: nrow: 478 rrow: 478) leaf: 0x410eed 4263661 (33: nrow: 477 rrow: 477) leaf: 0x410eee 4263662 (34: nrow: 478 rrow: 478) leaf: 0x410eef 4263663 (35: nrow: 477 rrow: 477) leaf: 0x410ef0 4263664 (36: nrow: 477 rrow: 477) leaf: 0x410ef1 4263665 (37: nrow: 478 rrow: 478) leaf: 0x410ef2 4263666 (38: nrow: 477 rrow: 477) leaf: 0x410ef3 4263667 (39: nrow: 477 rrow: 477) leaf: 0x410ef4 4263668 (40: nrow: 474 rrow: 474) leaf: 0x410ef5 4263669 (41: nrow: 448 rrow: 448) leaf: 0x410ef6 4263670 (42: nrow: 448 rrow: 448) leaf: 0x410ef7 4263671 (43: nrow: 448 rrow: 448) leaf: 0x410ef8 4263672 (44: nrow: 448 rrow: 448) leaf: 0x410ef9 4263673 (45: nrow: 448 rrow: 448) leaf: 0x410efa 4263674 (46: nrow: 448 rrow: 448) leaf: 0x410efb 4263675 (47: nrow: 448 rrow: 448) leaf: 0x410efc 4263676 (48: nrow: 448 rrow: 448) leaf: 0x410efd 4263677 (49: nrow: 448 rrow: 448) leaf: 0x410efe 4263678 (50: nrow: 448 rrow: 448) leaf: 0x410eff 4263679 (51: nrow: 448 rrow: 448) leaf: 0x410f00 4263680 (52: nrow: 448 rrow: 448) leaf: 0x410f01 4263681 (53: nrow: 448 rrow: 448) leaf: 0x410f02 4263682 (54: nrow: 448 rrow: 448) leaf: 0x410f03 4263683 (55: nrow: 448 rrow: 448) leaf: 0x410f04 4263684 (56: nrow: 448 rrow: 448) leaf: 0x410f05 4263685 (57: nrow: 448 rrow: 448) leaf: 0x410f06 4263686 (58: nrow: 448 rrow: 448) leaf: 0x410f07 4263687 (59: nrow: 448 rrow: 448) leaf: 0x410f08 4263688 (60: nrow: 448 rrow: 448) leaf: 0x410f89 4263817 (61: nrow: 448 rrow: 448) leaf: 0x410f8a 4263818 (62: nrow: 448 rrow: 448) leaf: 0x410f8b 4263819 (63: nrow: 448 rrow: 448) leaf: 0x410f8c 4263820 (64: nrow: 448 rrow: 448) leaf: 0x410f8d 4263821 (65: nrow: 448 rrow: 448) leaf: 0x410f8e 4263822 (66: nrow: 448 rrow: 448) leaf: 0x410f8f 4263823 (67: nrow: 448 rrow: 448) leaf: 0x410f90 4263824 (68: nrow: 448 rrow: 448) leaf: 0x410f91 4263825 (69: nrow: 448 rrow: 448) leaf: 0x410f92 4263826 (70: nrow: 448 rrow: 448) leaf: 0x410f93 4263827 (71: nrow: 448 rrow: 448) leaf: 0x410f94 4263828 (72: nrow: 448 rrow: 448) leaf: 0x410f95 4263829 (73: nrow: 448 rrow: 448) leaf: 0x410f96 4263830 (74: nrow: 448 rrow: 448) leaf: 0x410f97 4263831 (75: nrow: 448 rrow: 448) leaf: 0x410f98 4263832 (76: nrow: 448 rrow: 448) leaf: 0x410f99 4263833 (77: nrow: 448 rrow: 448) leaf: 0x410f9a 4263834 (78: nrow: 448 rrow: 448) leaf: 0x410f9b 4263835 (79: nrow: 448 rrow: 448) leaf: 0x410f9c 4263836 (80: nrow: 448 rrow: 448) leaf: 0x410f9d 4263837 (81: nrow: 448 rrow: 448) leaf: 0x410f9e 4263838 (82: nrow: 448 rrow: 448) leaf: 0x410f9f 4263839 (83: nrow: 448 rrow: 448) leaf: 0x410fa0 4263840 (84: nrow: 448 rrow: 448) leaf: 0x410fa1 4263841 (85: nrow: 448 rrow: 448) leaf: 0x410fa2 4263842 (86: nrow: 448 rrow: 448) leaf: 0x410fa3 4263843 (87: nrow: 448 rrow: 448) leaf: 0x410fa4 4263844 (88: nrow: 448 rrow: 448) leaf: 0x410fa5 4263845 (89: nrow: 448 rrow: 448) leaf: 0x410fa6 4263846 (90: nrow: 448 rrow: 448) leaf: 0x410fa7 4263847 (91: nrow: 448 rrow: 448) leaf: 0x410fa8 4263848 (92: nrow: 448 rrow: 448) leaf: 0x410fa9 4263849 (93: nrow: 448 rrow: 448) leaf: 0x410faa 4263850 (94: nrow: 448 rrow: 448) leaf: 0x410fab 4263851 (95: nrow: 448 rrow: 448) leaf: 0x410fac 4263852 (96: nrow: 448 rrow: 448) leaf: 0x410fad 4263853 (97: nrow: 448 rrow: 448) leaf: 0x410fae 4263854 (98: nrow: 448 rrow: 448) leaf: 0x410faf 4263855 (99: nrow: 448 rrow: 448) leaf: 0x410fb0 4263856 (100: nrow: 448 rrow: 448) leaf: 0x410fb1 4263857 (101: nrow: 448 rrow: 448) leaf: 0x410fb2 4263858 (102: nrow: 448 rrow: 448) leaf: 0x410fb3 4263859 (103: nrow: 448 rrow: 448) leaf: 0x410fb4 4263860 (104: nrow: 448 rrow: 448) leaf: 0x410fb5 4263861 (105: nrow: 448 rrow: 448) leaf: 0x410fb6 4263862 (106: nrow: 448 rrow: 448) leaf: 0x410fb7 4263863 (107: nrow: 448 rrow: 448) leaf: 0x410fb8 4263864 (108: nrow: 448 rrow: 448) leaf: 0x410fb9 4263865 (109: nrow: 448 rrow: 448) leaf: 0x410fba 4263866 (110: nrow: 448 rrow: 448) leaf: 0x410fbb 4263867 (111: nrow: 448 rrow: 448) leaf: 0x410fbc 4263868 (112: nrow: 448 rrow: 448) leaf: 0x410fbd 4263869 (113: nrow: 448 rrow: 448) leaf: 0x410fbe 4263870 (114: nrow: 448 rrow: 448) leaf: 0x410fbf 4263871 (115: nrow: 448 rrow: 448) leaf: 0x410fc0 4263872 (116: nrow: 448 rrow: 448) leaf: 0x411b31 4266801 (117: nrow: 448 rrow: 448) leaf: 0x411b32 4266802 (118: nrow: 448 rrow: 448) leaf: 0x411b33 4266803 (119: nrow: 448 rrow: 448) leaf: 0x411b34 4266804 (120: nrow: 448 rrow: 448) leaf: 0x411b35 4266805 (121: nrow: 448 rrow: 448) leaf: 0x411b36 4266806 (122: nrow: 448 rrow: 448) leaf: 0x411b37 4266807 (123: nrow: 448 rrow: 448) leaf: 0x411b38 4266808 (124: nrow: 448 rrow: 448) leaf: 0x411009 4263945 (125: nrow: 448 rrow: 448) leaf: 0x41100a 4263946 (126: nrow: 448 rrow: 448) leaf: 0x41100b 4263947 (127: nrow: 448 rrow: 448) leaf: 0x41100c 4263948 (128: nrow: 448 rrow: 448) leaf: 0x41100d 4263949 (129: nrow: 448 rrow: 448) leaf: 0x41100e 4263950 (130: nrow: 448 rrow: 448) leaf: 0x41100f 4263951 (131: nrow: 448 rrow: 448) leaf: 0x411010 4263952 (132: nrow: 448 rrow: 448) leaf: 0x411011 4263953 (133: nrow: 448 rrow: 448) leaf: 0x411012 4263954 (134: nrow: 448 rrow: 448) leaf: 0x411013 4263955 (135: nrow: 448 rrow: 448) leaf: 0x411014 4263956 (136: nrow: 448 rrow: 448) leaf: 0x411015 4263957 (137: nrow: 448 rrow: 448) leaf: 0x411016 4263958 (138: nrow: 448 rrow: 448) leaf: 0x411017 4263959 (139: nrow: 448 rrow: 448) leaf: 0x411018 4263960 (140: nrow: 448 rrow: 448) leaf: 0x411019 4263961 (141: nrow: 448 rrow: 448) leaf: 0x41101a 4263962 (142: nrow: 448 rrow: 448) leaf: 0x41101b 4263963 (143: nrow: 448 rrow: 448) leaf: 0x41101c 4263964 (144: nrow: 448 rrow: 448) leaf: 0x41101d 4263965 (145: nrow: 448 rrow: 448) leaf: 0x41101e 4263966 (146: nrow: 448 rrow: 448) leaf: 0x41101f 4263967 (147: nrow: 448 rrow: 448) leaf: 0x411020 4263968 (148: nrow: 448 rrow: 448) leaf: 0x411021 4263969 (149: nrow: 448 rrow: 448) leaf: 0x411022 4263970 (150: nrow: 448 rrow: 448) leaf: 0x411023 4263971 (151: nrow: 448 rrow: 448) leaf: 0x411024 4263972 (152: nrow: 448 rrow: 448) leaf: 0x411025 4263973 (153: nrow: 448 rrow: 448) leaf: 0x411026 4263974 (154: nrow: 448 rrow: 448) leaf: 0x411027 4263975 (155: nrow: 448 rrow: 448) leaf: 0x411028 4263976 (156: nrow: 448 rrow: 448) leaf: 0x411029 4263977 (157: nrow: 448 rrow: 448) leaf: 0x41102a 4263978 (158: nrow: 448 rrow: 448) leaf: 0x41102b 4263979 (159: nrow: 448 rrow: 448) leaf: 0x41102c 4263980 (160: nrow: 448 rrow: 448) leaf: 0x41102d 4263981 (161: nrow: 448 rrow: 448) leaf: 0x41102e 4263982 (162: nrow: 448 rrow: 448) leaf: 0x41102f 4263983 (163: nrow: 448 rrow: 448) leaf: 0x411030 4263984 (164: nrow: 448 rrow: 448) leaf: 0x411031 4263985 (165: nrow: 448 rrow: 448) leaf: 0x411032 4263986 (166: nrow: 448 rrow: 448) leaf: 0x411033 4263987 (167: nrow: 448 rrow: 448) leaf: 0x411034 4263988 (168: nrow: 448 rrow: 448) leaf: 0x411035 4263989 (169: nrow: 448 rrow: 448) leaf: 0x411036 4263990 (170: nrow: 448 rrow: 448) leaf: 0x411037 4263991 (171: nrow: 448 rrow: 448) leaf: 0x411038 4263992 (172: nrow: 448 rrow: 448) leaf: 0x411039 4263993 (173: nrow: 448 rrow: 448) leaf: 0x41103a 4263994 (174: nrow: 448 rrow: 448) leaf: 0x41103b 4263995 (175: nrow: 448 rrow: 448) leaf: 0x41103c 4263996 (176: nrow: 448 rrow: 448) leaf: 0x41103d 4263997 (177: nrow: 448 rrow: 448) leaf: 0x41103e 4263998 (178: nrow: 448 rrow: 448) leaf: 0x41103f 4263999 (179: nrow: 448 rrow: 448) leaf: 0x411040 4264000 (180: nrow: 448 rrow: 448) leaf: 0x411041 4264001 (181: nrow: 448 rrow: 448) leaf: 0x411042 4264002 (182: nrow: 448 rrow: 448) leaf: 0x411043 4264003 (183: nrow: 448 rrow: 448) leaf: 0x411044 4264004 (184: nrow: 448 rrow: 448) leaf: 0x411045 4264005 (185: nrow: 448 rrow: 448) leaf: 0x411046 4264006 (186: nrow: 448 rrow: 448) leaf: 0x411047 4264007 (187: nrow: 448 rrow: 448) leaf: 0x411048 4264008 (188: nrow: 448 rrow: 448) leaf: 0x411049 4264009 (189: nrow: 448 rrow: 448) leaf: 0x41104a 4264010 (190: nrow: 448 rrow: 448) leaf: 0x41104b 4264011 (191: nrow: 448 rrow: 448) leaf: 0x41104c 4264012 (192: nrow: 448 rrow: 448) leaf: 0x41104d 4264013 (193: nrow: 448 rrow: 448) leaf: 0x41104e 4264014 (194: nrow: 448 rrow: 448) leaf: 0x41104f 4264015 (195: nrow: 448 rrow: 448) leaf: 0x411050 4264016 (196: nrow: 448 rrow: 448) leaf: 0x411051 4264017 (197: nrow: 448 rrow: 448) leaf: 0x411052 4264018 (198: nrow: 448 rrow: 448) leaf: 0x411053 4264019 (199: nrow: 448 rrow: 448) leaf: 0x411054 4264020 (200: nrow: 448 rrow: 448) leaf: 0x411055 4264021 (201: nrow: 448 rrow: 448) leaf: 0x411056 4264022 (202: nrow: 448 rrow: 448) leaf: 0x411057 4264023 (203: nrow: 448 rrow: 448) leaf: 0x411058 4264024 (204: nrow: 448 rrow: 448) leaf: 0x411059 4264025 (205: nrow: 448 rrow: 448) leaf: 0x41105a 4264026 (206: nrow: 448 rrow: 448) leaf: 0x41105b 4264027 (207: nrow: 448 rrow: 448) leaf: 0x41105c 4264028 (208: nrow: 448 rrow: 448) leaf: 0x41105d 4264029 (209: nrow: 448 rrow: 448) leaf: 0x41105e 4264030 (210: nrow: 448 rrow: 448) leaf: 0x41105f 4264031 (211: nrow: 448 rrow: 448) leaf: 0x411060 4264032 (212: nrow: 448 rrow: 448) leaf: 0x411061 4264033 (213: nrow: 448 rrow: 448) leaf: 0x411062 4264034 (214: nrow: 448 rrow: 448) leaf: 0x411063 4264035 (215: nrow: 448 rrow: 448) leaf: 0x411064 4264036 (216: nrow: 448 rrow: 448) leaf: 0x411065 4264037 (217: nrow: 448 rrow: 448) leaf: 0x411066 4264038 (218: nrow: 448 rrow: 448) leaf: 0x411067 4264039 (219: nrow: 448 rrow: 448) leaf: 0x411068 4264040 (220: nrow: 448 rrow: 448) leaf: 0x411069 4264041 (221: nrow: 448 rrow: 448) leaf: 0x41106a 4264042 (222: nrow: 448 rrow: 448) leaf: 0x41106b 4264043 (223: nrow: 448 rrow: 448) leaf: 0x41106c 4264044 (224: nrow: 448 rrow: 448) leaf: 0x41106d 4264045 (225: nrow: 448 rrow: 448) leaf: 0x41106e 4264046 (226: nrow: 448 rrow: 448) leaf: 0x41106f 4264047 (227: nrow: 448 rrow: 448) leaf: 0x411070 4264048 (228: nrow: 448 rrow: 448) leaf: 0x411071 4264049 (229: nrow: 448 rrow: 448) leaf: 0x411072 4264050 (230: nrow: 448 rrow: 448) leaf: 0x411073 4264051 (231: nrow: 448 rrow: 448) leaf: 0x411074 4264052 (232: nrow: 448 rrow: 448) leaf: 0x411075 4264053 (233: nrow: 448 rrow: 448) leaf: 0x411076 4264054 (234: nrow: 448 rrow: 448) leaf: 0x411077 4264055 (235: nrow: 448 rrow: 448) leaf: 0x411078 4264056 (236: nrow: 448 rrow: 448) leaf: 0x411079 4264057 (237: nrow: 448 rrow: 448) leaf: 0x41107a 4264058 (238: nrow: 448 rrow: 448) leaf: 0x41107b 4264059 (239: nrow: 448 rrow: 448) leaf: 0x41107c 4264060 (240: nrow: 448 rrow: 448) leaf: 0x41107d 4264061 (241: nrow: 448 rrow: 448) leaf: 0x41107e 4264062 (242: nrow: 448 rrow: 448) leaf: 0x41107f 4264063 (243: nrow: 448 rrow: 448) leaf: 0x411080 4264064 (244: nrow: 448 rrow: 448) leaf: 0x411081 4264065 (245: nrow: 448 rrow: 448) leaf: 0x411082 4264066 (246: nrow: 448 rrow: 448) leaf: 0x411083 4264067 (247: nrow: 448 rrow: 448) leaf: 0x411084 4264068 (248: nrow: 448 rrow: 448) leaf: 0x411085 4264069 (249: nrow: 448 rrow: 448) leaf: 0x411086 4264070 (250: nrow: 448 rrow: 448) leaf: 0x411087 4264071 (251: nrow: 448 rrow: 448) leaf: 0x411088 4264072 (252: nrow: 448 rrow: 448) leaf: 0x411089 4264073 (253: nrow: 448 rrow: 448) ##对应BLOCK：69769 leaf: 0x41108a 4264074 (254: nrow: 388 rrow: 388) ##对应BLOCK：69770 ----- end tree dump
通过以上的DUMP，我们观察到，INDEX FULL SCAN从首先读取branch，接着按顺序，一个leaf一个leaf地读取，这样读取出来的数据也是有序，可以避免ORDER BY。
— The End —
关键字: SQL优化 | 性能优化
站内搜索