Skip scans

Is anybody using index skip scan feature? What would be a situation in which
the feature should be used? I have a SQL statement, part of  ETL process 
that I
have to tune. The initial reuslts are encouraging although not 
dramatic.  Does anybody
else have any type of practical experience with skip scans and index_ss 
hint?

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l

Other related posts: