Advantage Between Range Scan
& Skip Scan In Oracle
Can someone explain me how the
range scan is better than Skip Scan in Oracle 9i.
In index range scans,
Multiple rows with identical values
are sorted in ascending order by rowid.
in Skip scan
Skip scanning lets a composite index be split logically into smaller subindexes. In skip scanning, the initial column of the composite index is not specified in the query. In other words, it is skipped. The number of logical subindexes
is determined by the number of distinct values in the initial column. Skip
scanning is advantageous if there are few distinct values in the leading
column of the composite index and many distinct values in the nonleading
key of the index.
My understanding is,
Have a Oracle Question
Oracle Books
Oracle Application
Oracle Home
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|