Learn how to tune queries that contain the “AND” operator!
Conjunction queries, where the filter includes AND, can have poor performance due to the way they use (or do not use) indexes. This tutorial demonstrates some techniques for tuning them: a couple of hints, and some SQL rewrites that may help the Optimizer to do a better job.
Presenters: John Watson
Prerequisite: How to Read Execution Plans
Download the scripts and slides for this presentation: https://skillbuilders.com/wp-content/uploads/2023/03/Oracle-SQL-Tuning-Optimizing-AND.zip.
- Lectures 1
- Quizzes 0
- Duration 13 minutes
- Skill level All levels
- Language English
- Students 0
- Assessments Yes