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

"Why isn't Oracle using my index?!" is a common question people have when tuning SQL queries.

In this episode Chris compares two methods for finding all the red candies from party bags he's prepared. He shows how these are like a full table scan and an index range scan.

He goes on to compare the performance of these two approaches. He shows when a full table scan becomes more efficient than an index range scan and vice versa.

============================
The Magic of SQL with Chris Saxon

Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.

Видео A Story of Indexes and Full Table Scans: Finding All the Red Sweets Part 1 канала The Magic of SQL