Is there any way to map each of the SQL line to each of the Explain plan line..?

I have the big SQL and also I have the Explain plan for the same.....


Is there any way to map each of the SQL line to each of the Explain plan..?

Yes. EXPLAIN PLAN is meant for that purpose only.

Tamil

Well, not really. Sometimes you'd get multiple lines of the SQL being implemented as a single step in the explain plan, and sometimes the reverse.

Yopu have to recognise that the SQL (being a 4GL) is a statement of what result set you want, and the explain plan is like a procedural pseudo-code for how the optimizer is going to get that result for you, so you shouldn't expect a close correlation.

Yes ofcourse there is close relation between SQL and PLAN but not with number of lines in SQL and PLAN .. but in terms of operation/way of join and so..

Abhay.