Custom Search : Technical Guides Sybase Oracle UNIX Javascript

Technical Guides

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 */

Oracle : Related Topics

Oracle : PL-SQL : Forcing an index with a hint

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site

Get the latest Rocket99 news and tech tips via

Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site

Copyright © 2016 Stoltenbar Inc All Rights Reserved.