> If you don't know how to get an execution plan > my paper could help you > http://www.geocities.com/juancarlosreyesp/101basictunningonOracle9i.pdf Juan, There are 29 references to 'execution plan' in this paper, and it is not indexed. Clicking around on 29 instances of 'execution plan' to find out how to get the execution plan for a query is rather frustrating. If you want to help someone find the execution plan for a query, it would be more helpful to point them at the relevant documentation, with an example. Such as: http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_xplan.htm#1001497 Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------