-
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
-
Did you create a plan table and then insert this query into it? If not, check Oracle documentation.
goodhealth
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|