A Story of Indexes and Full Table Scans: Finding All the Red Sweets Part 1

[@kevinzhang8974]

I wish I had watched this long time ago. Even though I had used Oracle for so many years, I didn't pay attention to this kind of details related to performance tuning. Thank you Chris! I will dedicate my time to go through all your videos.

[@TheMagicofSQL]

Thanks, as they say better late than never :)

[@GeethaAyurKitchen]

This is the best way to explain the concept in a very simple terms. I was like visualising the things when you are explaining. Thanks for such a great content. Really appreciate your efforts.

[@TheMagicofSQL]

You're welcome, thanks!

[@oussamaelhousni5665]

you are a really sql wizard,your videos must have more views

[@TheMagicofSQL]

Thanks for the support! Please help by sharing these videos :)

[@OrganisewithPranav]

Wow...Your explanations are crystal clear...Thanks for Sharing Knowdedge

[@TheMagicofSQL]

You're welcome, thanks Pranav!

[@robertczaja176]

Well explained!

[@ngotiensy1318]

so helpful. thanks

[@MsMassi1]

thanks.. NICE VIDEO. Very useful for me.

[@souravsuman1993]

can you explain how come the execution plan for same query is different based on data. for one case it shows full table scan and for another case it shows index range scan.

[@jb31842]

I was about to post a comment on a major flaw with the analogy, but I just heard your closing teaser for the next installment, so you've probably got it covered and I just need to be patient. ;D

[@TheMagicofSQL]

+Jason Bucata There's more coming in this series Jason. Stay tuned - I think the next one will address what you're getting at :)

[@chelseali4463]

Great explanation! This makes a lot of sense to me now!

[@TheMagicofSQL]

Thanks, glad you found this useful :)

[@prophess710]

Finding all the sweets: Take a look in the box!

[@sylwiatr5560]

So great, love it

[@matspring]

yum yum sweeties! Great vid

[@TheMagicofSQL]

Yum indeed! Thanks :)