Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Composite indices and skip scanning
Hi, Chris!
CBO will only choose a INDEX SKIP SCAN if that access path has a lower cost than other alternatives.
CBO calcluates the cost for a ISS to be:
BLEVEL + #of distinct values of skipped column(s).
Cheers / Jocke Treugut
www.treugut-tuning.com
Höstrusk och grå moln - köp en resa till solen på Yahoo! Resor på adressen http://se.docs.yahoo.com/travel/index.html
![]() |
![]() |