I Got a table with about 10000 records. When I use the query (for testing) SELECT * FROM <table> there is no problem with it....
But the query SELECT * FROM <table> ORDER BY date DESC (and column date is an unindexed column) the query never finishes.
quering the database with ORDER BY on an indexed column, the resultset is there in a couple of seconds.
Can anyone give me some advise?
View Complete Post