The only time I have used them is when its not worth having another index on
a table just for a small number of queries that require it. An existing
index with the skip scan capability gives 'good enough' performance. The
consistent gets appear to be much higher than having an optimal index in
9.2. I have not tested it in 10. I only tested it for OLTP type queries.
----- Original Message -----
From: "Mladen Gogala" <mgogala_at_allegientsystems.com>
To: "'Oracle-L (E-mail)'" <oracle-l_at_freelists.org>
Sent: Wednesday, December 29, 2004 1:47 PM
Subject: 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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 29 2004 - 13:50:18 CST
