Should Joins always be using an index? (where possible?)

[Ow Mun Heng]

I'm have a query like so

select
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA


select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A

whcih would be more efficient? using the where clause which uses the
index or the one which isn't index?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]