Post reply

Multiple table joins and query efficiency

  • March 5, 2008 at 9:42 am

    #785597

    Here is my thought.

    Regardless the indexes, there is no difference, assuming we only have full table scans. But there will be a lot of difference in 2X2 and 4X1 joins when . The efficiency of the joins heavily depends on how to join your tables, and how you use indexes.

    More input will be more than welcome.

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply