First page Back Continue Last page Overview Graphics

Workshop

V$SQL_PLAN

Notes:

V$SQL_PLAN Workshop

Execute the following query. Enter a unique string where requested before executing. This query is supplied as v$sql_plan_workshop.sql.
SQL> SELECT /* <<<enter a unique string before executing>>> */
2 order_no, company_name, description
3 FROM ord o, customer c, payment p
4 WHERE o.cust_no = c.cust_no and
5 o.payment_method = p.payment_method and
6 c.city = 'New York'
7 ORDER BY description;
Use the supplied script v$sql_plan.sql to display the actual plan used by the previous query. You can pass your unique string to the script on the command line. For example
SQL> @v$sql_plan argo