Originally posted by fossil
2. For joining large tables (million's of rows) you don't
need an index on any column in the where clause.

3. Multi table query will join the tables first and then
filter the rows according to the where clause. You should
not be having an index lookup for the filter.
These statements are obviously wrong.