Originally posted by tamilselvan
How ever, for efficient joining between 2 tables, you need to have indexes on both tables.
* another-sharp-intake-of-breath *

I would say that it sometimes helps to have an index on one table -- depends on the type of join and the data volumes involved.