How Intelligent is the SQL Analysis Report in Oracle 23c?

How Intelligent is the SQL Analysis Report in Oracle 23c?

One of the nice little features in Oracle 23c is the “SQL Analysis Report”: When displaying execution plans, in some situations a report appears with suggestions on how to rewrite your SQL statement to improve performance.

What is behind this feature? Did Oracle just added a list of fixed recommendations, or is an intelligent set of rules implemented to suggest specific performance improvements? How useful are these recommendations? Do they also work for complex SQL queries? There is no information (so far) about this feature in the Oracle documentation, but the interest of the presenter was definitely aroused.

With various live examples I will show in which cases the “SQL Analysis Report” gives useful performance tips, how intelligent these recommendations are and where the limits of this new performance feature are.

About Dani

Dani Schnider works as Principal Oracle & DWH Consultant for Callista, a Swiss IT service provider for consulting and engineering. He has been working in database consulting for over 20 years, from 1999 to 2022 for Trivadis in Switzerland. Dani works with Oracle databases since 1994, since 1997 mainly in data warehouse projects.

His tasks include DWH architecture reviews, data modeling, ETL development and performance optimization in Oracle databases. Dani is Oracle ACE Director and co-author of the books “Data Warehousing mit Oracle – Business Intelligence in der Praxis” and “Data Warehouse Blueprints”, both published in German by Hanser-Verlag. On his blog “Data Warehousing with Oracle” he writes about design and performance topics related to Oracle data warehouses. He is a regular speaker at international Oracle user group conferences.