Oracle进阶与提高培训资料课件.pptVIP

案例：解读sql语句执行计划 SQL select count(*) from lpmnt; COUNT(*) 1155 Execution Plan Plan hash value: 3530445977 | Id | Operation | Name | Rows | Cost (%CPU)| Time | | 0 | SELECT STATEMENT | | 1 | 3 (0)| 00:00:01 | | 1 | SORT AGGREGATE | | 1 | | | | 2 | INDEX FAST FULL SCAN| LPMNT_DBID_IDX | 1102 | 3 (0)| 00:00:01 | Note - dynamic sampling used for this statement Statistics 509 recursive calls 0 db block gets 190 consistent gets 10