| Explain Plan in TOAD & SQLPLUS [message #32722] |
Thu, 02 September 2004 13:17  |
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 #32731 is a reply to message #32722] |
Thu, 02 September 2004 23:45  |
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 ) ;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
