Re: how force mysql to use certain indexes

2001-04-24 Thread Fred van Engen
Hi, On Tue, Apr 24, 2001 at 10:44:59AM -0400, Vivek Khera wrote: > > "PJM" == Patrick J Militzer <[EMAIL PROTECTED]> writes: > > PJM> I'm using mysql 3.22.27. How can I force mysql to use index's in > PJM> my select statement? > > You don't. SQL is a 4GL and you only describe what you wan

Re: how force mysql to use certain indexes

2001-04-24 Thread Vivek Khera
> "PJM" == Patrick J Militzer <[EMAIL PROTECTED]> writes: PJM> I'm using mysql 3.22.27. How can I force mysql to use index's in PJM> my select statement? You don't. SQL is a 4GL and you only describe what you want, and it is up to the language interpreter and optimizer to do it efficiently