Oracle SQL Tuning - Optimizing OR and IN

Published: 07 October 2022
on channel: SkillBuilders

1,196

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...

On this page of the site you can watch the video online Oracle SQL Tuning - Optimizing OR and IN with a duration of hours minute second in good quality, which was uploaded by the user SkillBuilders 07 October 2022, share the link with friends and acquaintances, this video has already been watched 1,196 times on youtube and it was liked by 28 viewers. Enjoy your viewing!

38,835

566