Tune Your SQL Without Hints Or Indexes!

10:30 AM–11:30 AM Apr 9, 2019

CC 2ND FL 210B


Session ID: 285


This presentation explores the underutilized art of rewriting a SQL query in order to make it run faster. Learn how to make your SQL query performance skyrocket simply by changing the SQL text! "But I can't change the queries that run in my database," you say. Not a problem! We demonstrate how you can hurdle this issue, too.

Objective 1: Attendees will be able to look for and identify opportunities for query tuning by modifying the SQL text of a query so that expensive operations can be avoided or reduced.

Objective 2: Attendees will learn how to rewrite SQL queries that are "unchangable" using the DBMS_ADVANCED_REWRITE and DBMS_SQL_TRANSLATOR packages.

Objective 3: Attendees will have a better understanding of how to find "mistakes" in queries, such as accidental implicit type conversion, accidentally foiling subquery unnesting, etc.

Audience: Mid-Level