Achieving an ORDER BY

[DaveH]

I have a very large dataset (over 500,000 rows) of names. If I include an ORDER BY clause in the SQL, the table takes a long time to open. So I don't do that. BUT when I use QBE, I would like the result set to come up "sorted" with an ORDER BY FULLNAME clause.

Where would the best place be to adjust the SQL. Can't do it in BeforeQBE, because the dataset wouldn't be open at that point.

Is there any way that I'm missing to add an ORDER BY Clause to the QBE Statement?

Dave

 

[genetics]

Hi

First of all: 500.000 is not much.
'Order by' takes so much time probably because you forget to create index...
With index it should be quick-and-easy..
Rest about QBE - sorry, but I can't understand where the problem is...

Regs.
Lukjel