Skip scans

  • From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
  • To: "'Oracle-L (E-mail)'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 29 Dec 2004 13:47:12 -0500

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: