A new flavour on the classic conundrum: Why is the optimizer opting for a full scan when it is "obvious" that an index should be used? In this video, the mystery was compounded by the fact that the EXPLAIN PLAN suggested an index would be used, but the EXECUTION PLAN ended up using a full table scan.
Follow me!
blog: connor-mcdonal...
twitter: / connor_mc_d
The Podcast!
podcasts.apple...
open.spotify.c...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
A free Oracle database forever ?! Oh yes indeed!
www.oracle.com...
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla
#oracle #sql #indexes
Негізгі бет Slow query! Why didn't the optimizer use my index?
Пікірлер: 8