Anup Shukla schrieb:
C.R.Vegelin wrote:
Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
AFAIK, MySQL (atleast from version 5.0 onwards) is capable of
using multiple indexes.
i have heard of something similar too, but cannot find any proof in the manual
only counterpart, f.e.:
http://dev.mysql.com/doc/refman/6.0/en/order-by-optimization.html
"In some cases, MySQL cannot use indexes to resolve the ORDER BY, although
it still uses indexes to find the rows that match the WHERE clause. These
cases include the following:
[...]
The key used to fetch the rows is not the same as the one used in the ORDER BY:"
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
