| 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 myODBC | Shangwu Qi | 13 Mar |
| • Re: USE INDEX(PRIMARY) with 3.23.12? | sasha | 14 Mar |
| • Re: USE INDEX(PRIMARY) with 3.23.12? (question about it) | David Diaz i Torrico | 14 Mar |
| • Re: USE INDEX(PRIMARY) with 3.23.12? (question about it) | Michael Widenius | 14 Mar |
| • Re: USE INDEX(PRIMARY) with 3.23.12? | sasha | 18 May |
| • Re: USE INDEX(PRIMARY) with 3.23.12? | Michael Widenius | 24 May |