Generating and displaying the execution plan of a SQL statement is a common task for most DBAs, SQL developers, and preformance experts as it provides them information on the performance characteristics of a SQL statement. An execution plan shows the detailed steps necessary to execute a SQL statement. These steps are expressed as a set of database operators that consumes and produces rows. The order of the operators and their implentation is decided by the query optimizer using a combination of query transformations and physical optimization techniques.
There are different instruments/methods you can use to look at the execution plan of a SQL statement:
There are different instruments/methods you can use to look at the execution plan of a SQL statement:
• STATS$SQL_PLAN (Statspack)
For clarity I am going to write different post for each of methods, so stay tuned :)
No comments:
Post a Comment