On 10/15/06, Freebat Wangh <[EMAIL PROTECTED]> wrote:
mysql> explain select lw.id, lw.sender as guest_id from gossip lw where
lw.owner = 21821 order by lw.id desc limit 18540, 20\G;
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: lw
type: ref
possible_keys: owner_id
key: owner_id
key_len: 4
ref: const
rows: 10646
Extra: Using where
1 row in set (0.03 sec)
it should be OK!
In fact when mysql uses filesort the column Extra is something like: "Using
where; Using filesort"
you can do this additional test:
explain select lw.id, lw.sender as guest_id from gossip lw where
lw.owner = 21821 order by lw.sender desc limit 18540, 20;
this query will use filesort!
--
http://www.openwebspider.org
http://www.eviltime.com
-
" Time is what we want most, but what we use worst "
