Thanks for your reply,
Just to be clear...performing my query without the order by clause will
always return the list sorted by the primary identifier?
so that
SELECT SubmitId from BINDSubmit ORDER BY SubmitId == SELECT SubmitId from
BINDSubmit
in this case
Marc
Dathan Pattishall wrote:
This te
This tells the optimizer to do a table scan. If you used INNODB it's
already sorted by the primary key since INNODB supports clustered
indexes. Doing a table scan on innodb is very slow due to it's MVCC
control.
It's going to take a long time.
DVP
Dathan Vance Pattishall http://www.fri