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).