Loading…
Sangam17 has ended
Please note: Agenda and speakers are subject to change.
Saturday, December 9 • 11:55 - 12:45
Why Isn't My Query Using an Index? An Introduction to SQL Performance LIMITED

Log in to save this to your schedule and see who's attending!

Feedback form is now closed.
Limited Capacity seats available

Why isn't my query using an index? is a common question people have when tuning SQL.

This talk explores the factors that influence the optimizer's decision behind this question. It does so by comparing fetching rows from a database table to finding all the red M&Ms their packets. It contrasts using an index range scan and a full table scan to do this.

It introduces the concepts of blocks and the clustering factor. It discusses how these affect the optimizer's calculations. It goes on to demonstrate how these concepts work in practice using real SQL queries.

This session is intended for developers who want to learn the basics of how the optimizer chooses between an index range or full table scan and how to make their SQL run quickly!

Speakers
avatar for Chris Saxon

Chris Saxon

Developer Advocate, Oracle, UK
Chris Saxon is an Oracle Developer Advocate for SQL. His job is to help you get the best out of the Oracle Database and have fun with SQL!To help you with this he blogs at All Things SQL. He also creates videos combining SQL and magic on YouTube at The Magic of SQL.If you have questions... Read More →


Saturday December 9, 2017 11:55 - 12:45
Room 1 (Hall 1)