Oracle SQL Tuning - Optimizing OR and IN

Getting poor performance from an Oracle SQL query that contains OR or IN? Disjunction queries, where the filter includes OR or IN, can have poor performance due to the way they use (or do not use) indexes. This tutorial demonstrates some techniques for tuning them.

Background - Many SQL queries include multiple predicates combined with an “OR” operator, aka the “disjunction” operator. Did you know that B-Tree indexes are of limited value with these predicates? Composite indexes and bitmaps might help, but, all too often, the optimizer (CBO) will produce a Full Table Scan. Learn how to tune these queries in about 12 minutes!

Visit the tutorial web page to Download the Sample SQL used in this Tutorial: https://skillbuilders.com/course/orac...

Contents of this video:
00:00 - Introduction to Oracle SQL Tuning - Optimizing OR and IN
00:32 - OR: The Disjuction Operator
03:42 - Hints: The Hacker's Solution
08:29 - Let's Try Tuning the SQL
12:40 - Summary to Oracle SQL Tuning - Optimizing OR and IN

Attend instructor-led online class with this instructor, Oracle Certified Master John Watson of SkillBuilders! https://skillbuilders.com/course/orac...

Hire John for Oracle DBA Services...for more info visit: https://skillbuilders.com/database-ad...

About Skillbuilders:
SkillBuilders, 25 years of success stories for Oracle Database Administration, APEX Development, APEX Hosting on AWS and Training.

Subscribe to our Channel and see hundreds of SkillBuilders Free Tutorials or watch on web site:
https://skillbuilders.com/free-oracle...