Index funzt nicht mit kleiner-gleich

[Carsten Wawer]

hi,

thats it! danke.

> "Sometimes MySQL will not use an index, even if one is available. One
> way this occurs is when the optimizer estimates that using the index
> would require MySQL to access a large percentage of the rows in the
> table. (In this case, a table scan is probably much faster, because it
> will require many fewer seeks.) However, if such a query uses LIMIT to
> only retrieve part of the rows, MySQL will use an index anyway,
> because it can much more quickly find the few rows to return in the
> result."
 
http://dev.mysql.com/doc/mysql/en/MySQL_indexes.html

gruß!
carsten

-- 
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql