Very glad I discovered this forum and your blog! Some very interesting reads! I am working on my thesis for my IT-Bachelor and it involves performance, so any help is very much appreciated.
This may sound like an Amateur Question but I’m really mystified as to why MySQL chooses to use a Filesort and not my Index to process this statement:
SELECT * FROM
Kontakt ORDER BY
The table is created like this:
id int(11) NOT NULL default ‘0’,
PRIMARY KEY (
I am using MySQL 5.0.22.
In the MySQL Reference it says that my select statement certainly would be using the index created…but it doesnt show when using explain and also performs slowly when having thousands of rows…
Thanks for any hints…I don’t mind being stupid, as long as someone is able to explain it to me;)