MySQL Forums
Forum List  »  Optimizer & Parser

Why do mysql use temporary and filesort here?
Posted by: Johannes Fosseus
Date: September 08, 2006 04:50AM

I cant figure out why mysql have to use 'Using temporary' and 'Using filesort' to run
my simple question? Seems to that that is not optimal for performance, Please somone give me some advise on how I can optimize this one.

best regards / johannes.


SELECT junior_writer.writername, junior_writer.writerid
FROM junior_writer, junior_buddy
WHERE junior_writer.writerid = junior_buddy.writerid
AND junior_buddy.buddyid = 1
ORDER BY junior_writer.writername ASC

Table: junior_buddy
Extra: Using temporary; Using filesort
Possible_keys: writerid,buddyid
Key: buddyid

Table: junior_writer
Extra:
Possible_keys: PRIMARY
Key: PRIMARY

Table: junior_buddy
writerid int(11)
buddyid int(11)
Index on 'writerid', 'buddyid'

Table: junior_writer
writerid int(11)
Index: writerid PRIMARY

Options: ReplyQuote


Subject
Views
Written By
Posted
Why do mysql use temporary and filesort here?
3309
September 08, 2006 04:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.