Monday, January 21, 2008

Cost of Query in Oracle

One way to tell what is happening when a query is executed on Oracle is to open up SQL Plus and type the following before your SQL statement you want to analyze. Turning Autotrace on will give you performance cost in the way of an Execution Plan.
SET AUTOTRACE ON
When you are done, turn it off with
SET AUTOTRACE OFF

No comments: