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.