"ORDER BY" without large table scans and filesort

[Paul M]

Originally Posted by KirbyDE

Hmm ...

[sql]EXPLAIN SELECT * FROM thread ORDER BY threadid DESC LIMIT 1[/sql]

 
id  	select_type	table	type	possible_keys	key	key_len		ref	rows  	 Extra
1 	SIMPLE 		thread	ALL	NULL		NULL 	NULL		NULL	32

I only got 32 Threads on my testboard, so this is a full tablescan.
Any ideas?

If I were you I would check/rebuild your indexes, you should get this ;

[sql]EXPLAIN SELECT * FROM thread ORDER BY threadid DESC LIMIT 1 [/sql]

table	type	possible_keys	key  	key_len	ref	rows	Extra  
thread	index	NULL		PRIMARY	4	NULL	82