Index Skip Scan

(Hemant K Chitale) We know that an Index Skip Scan operation is when Oracle uses an Index of which the leading column is not a query predicate. For example, an index on (A,B,C) is not normally expected to be used for a query against ‘B’ and ‘C’. Yet, Oracle may use the index if it finds that the “co

Read More - Register for Free Membership