timercord index is not hit !! why ? how to amend ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
+---+--+---+--+-+--+--+-
k ---+
k 1 row in set (0.00 sec)
k Pls help timercord index is not hit !! why ? how to amend ?
MySQL doesn't use indexes if query require to access more than 30%
rows in the table. You can find some more info about how
|
+---++--+--+-+---+-+--+
when i commit this select:
'SELECT * FROM reporting WHERE jahr=2002;'
it seems that the index isn't hit.
mysql explain select * from reporting where jahr=2002
|1 | jahr|
SB A |NULL | NULL |
SB
+---++--+--+-+---+-+--+
SB when i commit this select:
SB 'SELECT * FROM reporting WHERE jahr=2002;'
SB it seems that the index isn't hit.
SB mysql