index range scan vs index skip scan
Hi
I am seeing different cost for a single SQL_ID. Cost is high when optimizer is doing index skip scan, while cost reduced to 4 times with index range scan.
Could someone brief about this phenomenon. And, if skip scan is expensive, can we have optimizer use better one instead?
We have autostats job enabled and I reviewed the histograms and they do not look stale, so as the stats.
Thanks
Siraj