After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent beer selection!
|
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 */
|
|
|
|
