About this document
Oracle Index Skip Scan Explained by Subhasis Maity is a document available to read on EtoBox.
The document discusses index skip scans, which allow a composite index to be used even if the leading column is not specified in the query predicate. With a skip scan, the composite index is logically split into subindexes based on the distinct values in the leading column. The database then performs separate index searches on each subindex to retrieve the rows matching the predicate on the non-leading column, without having to consider the leading column. Skip scans are beneficial when the leading column h
- Author
- Subhasis Maity
- Language
- EN