explain plan
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: explain plan

  1. #1
    Join Date
    Jan 2001
    Posts
    318

    Angry

    Why can't I do EXPlain paln on this query ???

    SET AUTOTRACE TRACEONLY EXPLAIN STATISTICS;
    SELECT mwebWork.Work_ID, mwebWork.Work_Int_Ext7, mwebWork.Work_Plan_Finish, mwebWork.Work_Status, mwebWork.Work_Level, mwebWork.Work_Description, mwebWork.Work_Par3, mwebWork.Work_Int_Ext8, mwebWork.Work_Plan_Start, mwebWork.Work_Par3, project.Work_Item_Code, project.Work_Description, project.Work_Int_Ext8 FROM mwebWork, mwebWork project WHERE (NVL(mwebWork.Work_Sec_ID,0)=0 OR mwebWork.Work_Sec_ID=4 OR mwebWork.Work_Sec_ID=1 OR mwebWork.Work_Sec_ID=65) AND mwebWork.Work_int_ext3=545 AND mwebWork.Work_Entity_Type=4 and mwebWork.Work_id NOT IN (select Auth_Work_ID from mwebauth) AND project.Work_ID=mwebWork.Work_Par3 AND project.Work_ID=mwebWork.Work_Par3 AND project.Work_ID=mwebWork.Work_Par3 ORDER BY mwebWork.Work_Par3, mwebWork.Work_Description;


    It just say 20,000 ....i.e no of rows. but no statistics.
    Does it have to be a simple query to explain plan.
    When I do select count(*) from xx; it works..
    Sonali

  2. #2
    Join Date
    Dec 2000
    Posts
    75
    Did you create a plan table and then insert this query into it? If not, check Oracle documentation.

    goodhealth

  3. #3
    Join Date
    Jan 2001
    Posts
    318
    Yes, I do have plan_table and this is happening only for this query why ?
    Sonali

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width