List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:March 14 2000 12:30pm
Subject:Re: USE INDEX(PRIMARY) with 3.23.12? (question about it)
View as plain text  
Hi!

>>>>> "David" == David Diaz i Torrico <ddiaz@stripped> writes:

David> What's the use of "USE INDEX"? indexes aren't supposed to be chosen and
David> used automagicaly ??

Yes indexes are normally choosed automaticly, , but in some cases the
optimizer may do things wrong and by specifying USE INDEXES you can
force the optimizer to only look at certain indexes.

Regards,
Monty
Thread
USE INDEX(PRIMARY) with 3.23.12?(David Sklar)13 Mar
  • Write Conflict Error returned from myODBCShangwu Qi13 Mar
  • Re: USE INDEX(PRIMARY) with 3.23.12?sasha14 Mar
    • Re: USE INDEX(PRIMARY) with 3.23.12? (question about it)David Diaz i Torrico14 Mar
      • Re: USE INDEX(PRIMARY) with 3.23.12? (question about it)Michael Widenius14 Mar
  • Re: USE INDEX(PRIMARY) with 3.23.12?sasha18 May
    • Re: USE INDEX(PRIMARY) with 3.23.12?Michael Widenius24 May