MySQL Performance: MySQL => IN(...) ORDER BY ...

Members

Help

Home

Home » Performance » MySQL » IN(...) ORDER BY ...

Show: Today's Messages :: Show Polls :: Message Navigator

IN(...) ORDER BY ... [message #1018]

Sun, 01 April 2007 11:40

morpika
Messages: 1
Registered: April 2007

Junior Member

Hi!

I have a very simple table:

CREATE TABLE `users` (
`user_id` MEDIUMINT( 7 ) NOT NULL ,
`user_name` VARCHAR( 30 ) NOT NULL
)

ALTER TABLE `my_users` ADD INDEX ( `user_id` , `user_name` )

I would like to select specified users ordered by their name!

SELECT * FROM `users` WHERE `user_id` IN (1, 2, 3, 11, 22, 33) ORDER BY `user_name`

Unfortunately i can't rid of the filesort Sad

Explain says:

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE my_users range user_id user_id 3 NULL 7 Using where; Using index; Using filesort

I have 18.610 rows in the table:

1. Jane
2. John
3. Smith
ect...

Report message to a moderator