Of Interest
Business Intelligence and Analytics
Oracle Training
|
Oracle
»
PL-SQL
»
Performance
»
Showplan
Showing the Query Plan
In many cases it is beneficial to see what indexes are being used in a query,
or if it is running a table scan. Here are the commands which will
cause the internal optimization details to display.
-- show query plan
set autotrace on
/* Query Text Here */
-- show query plan, without running the SQL!
set autotrace traceonly explain
/* Query Text Here */
|
|
|
Get the latest Rocket99 news and tech tips via
|
