Re: Access and Filter Predicate on same execution plan line

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 17 Aug 2021 20:25:40 -0400

Index skip scan usually is not very fast. I guess it might be fast but I haven't seen such a case.  Flying saucers might exist but I haven't seen one yet. And when you take a look at the number of the logical gets caused by the index skip scan, you will see something very similar to the fast full scan.

On 8/17/21 4:31 PM, Andy Sayer wrote:

An index skip scan is simple and can be very fast (nothing like a fast full scan).

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

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


Other related posts: