List:General Discussion« Previous MessageNext Message »
From:Colin McKinnon Date:January 17 2000 4:53pm
Subject:Re: Newbie Question - Switch Index
View as plain text  
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

Thread
Newbie Question - Switch IndexDavid Jourard17 Jan
  • Re: Newbie Question - Switch IndexColin McKinnon17 Jan