Slow query! Why didn't the optimizer use my index?

Описание к видео Slow query! Why didn't the optimizer use my index?

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: https://connor-mcdonald.com
twitter:   / connor_mc_d  

The Podcast!
https://podcasts.apple.com/au/podcast...
https://open.spotify.com/show/5dqVVft...

Subscribe for new tech videos every week

Other social media channels here: https://linktr.ee/connor

A free Oracle database forever ?! Oh yes indeed!

https://www.oracle.com/cloud/free

Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla

#oracle #sql #indexes

Комментарии

Информация по комментариям в разработке