Selasa, 17/12/2002 7:47:38, Jeremy menulis:

JZ> I'm  not  quite  sure what you're after, but MySQL 4.0 has support
JZ> for  reading  indexes in reverse order in some circumstances. This
JZ> greatly speeds up some queries that were slow in 3.23.

I'm using MySQL 4.0.4-beta. For example:

EXPLAIN SELECT *
FROM news
where date <= '2002-12-31'
order by date desc

table type possible_keys key  key_len ref  rows  Extra
news  ALL  date          NULL NULL    NULL 14138 where used

Or is that normal ? Any sample 'circumstances' ? TIA.

Tertanda,
Oguds [36856104]



---------------------------------------------------------------------
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