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