Sebastian Mendel schrieb:
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:"
i can only find one source in the manual, where MySQL is using more than on
index:
http://dev.mysql.com/doc/refman/6.0/en/index-merge-optimization.html
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]