Hi,

Does any one have idea to have the Queries be in a proper Order.

Like Select c1,c2,c3,c4 .. Which Columns to be Selected 1st.
From t1, t2,t3,t4,t5.. Which table to be used first .. Larger or Smaller and same in Where
Where t1.a=t2.a and t2.b=t3.c etc... Which order for this clause, Bigger tables first or What? and Does it make any difference if you Bigger column Left of the Equation and smaller column on the Rights.

Please elaborate the best Order to Construct the Query.
I know the Queries are read Bottom Up and the most restrictive conditions should be the last in where clause.

Thanks..