Re: Access and Filter Predicate on same execution plan line
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 17 Aug 2021 20:25:40 -0400
Message-ID: <25aec426-7091-62a7-3015-028f4ae6250b_at_gmail.com>
Date: Tue, 17 Aug 2021 20:25:40 -0400
Message-ID: <25aec426-7091-62a7-3015-028f4ae6250b_at_gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 18 2021 - 02:25:40 CEST