Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Skip scans

Skip scans

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Wed, 29 Dec 2004 13:47:12 -0500
Message-ID: <41D2FBB0.402@allegientsystems.com>


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 Received on Wed Dec 29 2004 - 12:46:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US