RE: Index skip scan

Generally speaking, I've never seen CBO chose skip scan by itself. INDEX_SS may help, if you're

certain that it will improve performance.  

--

Mladen Gogala

Ext. 121

From: Hameed, Amir [mailto:Amir.Hameed_at_xerox.com] Sent: Tuesday, September 20, 2005 12:58 PM To: oracle-l_at_freelists.org
Subject: Index skip scan  

Folks,
Does anyone know that in order for the optimizer to choose "Index skip scan" on a concatenated index where the first column is not very selective but the second one is, approximately what type of selectivity on the leading column the Optimizer look for before deciding to take this route?

Thanks
Amir

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 20 2005 - 13:20:12 CDT