I would like to view explain plan output in sqlplus.<\/p>\n
One easy approach is to set autotrace. You can set autotrace on<\/strong> to show query statistics as well as an exection plan. You can also view only the execution plan, for example,<\/p>\n Alternatively, you can use EXPLAIN PLAN FOR<\/strong> in front of your sql-statement, but viewing the plan output is less-intuitive, e.g.,<\/p>\n I would like to view explain plan output in sqlplus. One easy approach is to set autotrace. You can set autotrace on to show query statistics as well as an exection plan. You can also view only the execution plan, for example, foo_owner@FOO> set autotrace on explain foo_owner@FOO> SELECT COUNT(*) FROM tax_facts WHERE create_date EXPLAIN […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[18],"tags":[],"_links":{"self":[{"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/posts\/571"}],"collection":[{"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/comments?post=571"}],"version-history":[{"count":4,"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/posts\/571\/revisions"}],"predecessor-version":[{"id":700,"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/posts\/571\/revisions\/700"}],"wp:attachment":[{"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/media?parent=571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/categories?post=571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.avant.net\/q\/wp-json\/wp\/v2\/tags?post=571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\r\nfoo_owner@FOO> set autotrace on explain\r\nfoo_owner@FOO> SELECT COUNT(*) FROM tax_facts WHERE create_date <= TO_DATE('10-JAN-12', 'DD-MON-YY');\r\n\r\n COUNT(*)\r\n----------\r\n 3768447\r\n\r\n\r\nExecution Plan\r\n----------------------------------------------------------\r\nPlan hash value: 3136400752\r\n\r\n--------------------------------------------------------------------------------------\r\n| Id | Operation\t | Name\t | Rows | Bytes | Cost (%CPU)| Time |\r\n--------------------------------------------------------------------------------------\r\n| 0 | SELECT STATEMENT | \t |\t 1 |\t 8 |\t1988 (5)| 00:00:36 |\r\n| 1 | SORT AGGREGATE | \t |\t 1 |\t 8 |\t\t |\t |\r\n|* 2 | INDEX FAST FULL SCAN| TAXFCT_CRTDT |\t3774K|\t 28M|\t1988 (5)| 00:00:36 |\r\n--------------------------------------------------------------------------------------\r\n\r\nPredicate Information (identified by operation id):\r\n---------------------------------------------------\r\n\r\n 2 - filter(\"CREATE_DATE\"<=TO_DATE('10-JAN-12','DD-MON-YY'))\r\n\r\nfoo_owner@FOO>\r\n<\/pre>\n\r\nfoo_owner@FOO> EXPLAIN PLAN FOR SELECT COUNT(*) FROM tax_facts WHERE create_date <= TO_DATE('10-JAN-12', 'DD-MON-YY');\r\n\r\nExplained.\r\n\r\nfoo_owner@FOO> SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());\r\n\r\nPLAN_TABLE_OUTPUT\r\n------------------------------------------------------------------------------------------------------------------------\r\nPlan hash value: 3136400752\r\n\r\n--------------------------------------------------------------------------------------\r\n| Id | Operation\t | Name\t | Rows | Bytes | Cost (%CPU)| Time |\r\n--------------------------------------------------------------------------------------\r\n| 0 | SELECT STATEMENT | \t |\t 1 |\t 8 |\t1988 (5)| 00:00:36 |\r\n| 1 | SORT AGGREGATE | \t |\t 1 |\t 8 |\t\t |\t |\r\n|* 2 | INDEX FAST FULL SCAN| TAXFCT_CRTDT |\t3774K|\t 28M|\t1988 (5)| 00:00:36 |\r\n--------------------------------------------------------------------------------------\r\n\r\nPredicate Information (identified by operation id):\r\n---------------------------------------------------\r\n\r\n 2 - filter(\"CREATE_DATE\"<=TO_DATE('10-JAN-12','DD-MON-YY'))\r\n\r\n14 rows selected.\r\n\r\nfoo_owner@FOO> \r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"