Re: how force mysql to use certain indexes

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

> "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

how force mysql to use certain indexes

Hi there, I'm using mysql 3.22.27. How can I force mysql to use index's in my select statement? When I use explain to see what the optimiser is doing I see that its using the wrong index. When I try to use the USE INDEX(KEY1,KEY) i get a syntax error. Any ideas Thanks, Pat Pat Militzer Tec