explain plan

[sonaliak]

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..

[goodhealth]

Did you create a plan table and then insert this query into it? If not, check Oracle documentation.

[sonaliak]

Yes, I do have plan_table and this is happening only for this query why ?