Hi I have a database with just over 10,000 records. with the following structure: id, compid, name, score, and about 10 other fields
I have indexed id, compid, score about 10 records out of the 10,000 have a compid of 2 when i do select * from table where compid = 2 it was slow until i indexed the compid and now is <1 second, but select * from table where compid = 2 order by score takes around 15 seconds and has alot of HDD activiry. Any way to speed this up? its driving me nuts. -- Dave