• Yes, Because in one of my query, i am joining with 3 tables. And table 1 have the 1 million record, 2 Lakh and table3 have 10 thousands.

    I am using inner join, so question came on my mind how order of join works. For the above case it is important to know.