The Explain Plan is a visualization of this execution plan. The cost-based optimizer arrives at this (I spend a half a day on this in my SQL Performance Tuning class) via statistics and math. Getting an Explain PlanĮvery SQL statement has an execution plan. In the Related Information at the bottom of this blog, I have included links to better understand the Explain Plan process and the contents of the Explain Plans. This series of blog posts will focus on how Toad can display SQL execution plans and the usefulness of this information. SQL performance is affected by a number of factors that include data distribution, coding style, and available other resources such as indexing and partitioning. The faster this application SQL executes, the more quickly data is returned to your application.

There is far more content on this topic than what I can share in this short blog post, but it goes to say that Toad for Oracle is the best SQL Performance Tuning tool available, in my humble opinion. Toad for Oracle exposes the execution plan for any given SQL statement. The Oracle database functions totally on SQL being submitted by your application process (application SQL) and by Oracle itself to process your submitted SQL (dictionary SQL or recursive SQL).

Using Oracle Optimizer hints with Toad for Oracle.

First in a three-part series, we'll highlight features in our different editions of Toad for Oracle, starting with Base (Explain Plan), then Xpert and concluding with DBA edition. SQL performance tuning is the focus of this blog and video tutorial series.

Toad pl sql