- Use PLAN_TABLE that comes with the schema
- Use TOAD_PLAN_TABLE (Created by Toad)
Option 1
Query user table for PLAN_TABLE
Select * from user_tables where table_name ='PLAN_TABLE'
Set this table in Toad Menu
View->Toad Options-> Select Oracle
on the right had side, you will see options for Explain Plan
Option 2
You can create TOAD_PLAN_TABLE, by running TOADPREP.SQL (Found in older version of Toads). This is no longer available in Toad 10
No comments:
Post a Comment