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.