On 8/20/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
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?
If you join using the field that is indexed, this will use an index.
If you join using the field that isn't indexed, it can't use an index.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
