fahad_direct - 4:00 pm on Dec 23, 2010 (gmt 0)

Thanks Peter, I have to actually compare the records of 2 tables each having approximately 1.5 million records. I am joining both tables and finding updated or new records in t1 table.
I am going with your second option and already using the big index on all my joined columns.