Hello,

Perhaps I don't understand indexes but I was wondering how to improve teh
performance of a query on an indexed column that uses MAX().

mysql> explain select max(master_mtime) from redirects where uri_scheme =
'http';
+-----------+------+-----------------------------+----------------+---------+-------+---------+------------+|
+ table     | type | possible_keys               | key            | key_len
| ref   | rows    | Extra      |
+-----------+------+-----------------------------+----------------+---------+-------+---------+------------+|
+ redirects | ref  | full_uri_idx,uri_scheme_idx | uri_scheme_idx |      16
| const | 7694050 | where used |
+-----------+------+-----------------------------+----------------+---------+-------+---------+------------+1
+ row in set (0.01 sec)

There is an index on master_mtime but it's not listed by explain???

Perhaps MAX() uses the sort buffer?  If so, how can I work out what to
increase the sort buffer to, aside from guessing.

Thanks for any help

Richard



---------------------------------------------------------------------
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 PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to