Home » SQL & PL/SQL » Client Tools » Explain Plan in TOAD & SQLPLUS
Explain Plan in TOAD & SQLPLUS [message #32722] Thu, 02 September 2004 13:17 Go to next message
Shariq Tariq
Messages: 15
Registered: February 2004
Junior Member
I was using the TOAD explain plan to do some analysis on the queries. However, my colleage mentioned that TOAD explain plans are not the most reliable and I should be sticking to using explain plans from SQLPLUS. Why? I would ask him but he said he too has heard it

Shariq

 
Re: Explain Plan in TOAD & SQLPLUS [message #32723 is a reply to message #32722] Thu, 02 September 2004 13:53 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
There is no difference between the plan results in TOAD and SQL*Plus. All TOAD does is issue 'explain plan set statement_id = ... into plan_table for 'select ...' in the background.
Re: Explain Plan in TOAD & SQLPLUS [message #32731 is a reply to message #32722] Thu, 02 September 2004 23:45 Go to previous message
ultra.
Messages: 1
Registered: September 2004
Junior Member
For Toad, you should create
3 tables to use explain plan when
you click on the "ambulance"/"medical car" button.
Ultra.

---------------------------------------------------

CREATE TABLE TOAD_PLAN_SQL (
USERNAME VARCHAR2 (30),
STATEMENT_ID VARCHAR2 (32),
TIMESTAMP DATE,
STATEMENT VARCHAR2 (2000) ) ;

CREATE TABLE TOAD_PLAN_TABLE (
STATEMENT_ID VARCHAR2 (32),
TIMESTAMP DATE,
REMARKS VARCHAR2 (80),
OPERATION VARCHAR2 (30),
OPTIONS VARCHAR2 (30),
OBJECT_NODE VARCHAR2 (128),
OBJECT_OWNER VARCHAR2 (30),
OBJECT_NAME VARCHAR2 (30),
OBJECT_INSTANCE NUMBER,
OBJECT_TYPE VARCHAR2 (30),
SEARCH_COLUMNS NUMBER,
ID NUMBER,
COST NUMBER,
PARENT_ID NUMBER,
POSITION NUMBER,
CARDINALITY NUMBER,
OPTIMIZER VARCHAR2 (255),
BYTES NUMBER,
OTHER_TAG VARCHAR2 (255),
OTHER LONG ) ;

CREATE TABLE TOAD_PLAN_TABLE2 (
STATEMENT_ID VARCHAR2 (32),
ID NUMBER ) ;
Previous Topic: How to start Debugger in SQL*Navigator
Next Topic: Sql loader error -- Toad
Goto Forum:
  


Current Time: Tue Aug 04 14:30:29 CDT 2020