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

[skdas]

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

[tamilselvan]

Yes. EXPLAIN PLAN is meant for that purpose only.

Tamil

[slimdave]

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.

[abhaysk]

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.