Re: Newbie Question - Switch Index

[Colin McKinnon]

At 11:49 17/01/00 -0500, David Jourard wrote:
>somehow mySQL manages this automatically by looking at the WHERE clause to 
>determine what index to use.

Yes.

See 'EXPLAIN' in the manual. There has also been quite a lot of explanation
on the list as to how MySQL chooses the indices, and how to design them -
have a look in the archive.

HTH

Colin