• purushottam2 (1/28/2013)


    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.

    SQL query optimizer should (and most of the times it does) figure out the best sequence by itself.

    Saying that, I used to follow my old custom to drive query from the smallest table/data set...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]