Page History
...
Table 12-98 Extensive "Index Skip Scan" Access
...
Description |
---|
What to do |
...
next | Perform the following: |
...
|
...
|
...
|
Advice |
...
Perform one of the following options: |
...
|
...
|
...
|
...
Example | Table: TAB1 (C1 number, C2 number, C3 number, C10 Date) Index: IX1 (C1,C2) (C1 has two distinct values Yes and No) Statement: select * from TAB1 where C2=10; Execution plan uses Index Skip Scan on IX1. In this case Oracle has to perform two range scans on the index—one with a key of (Yes,10) and another with a key of (No,10)and then unite the results. The more distinct values defined for C1, the more index scanning required. Defining a new index on (C2), or changing the column sequence in IX1 to be (C2,C1), enables a more efficient access path for the Index Range Scan. |
Precise. Performance intelligence from click to storage. Learn more > >
...