I am running a SQL query on a DBase table with about 12 000 entries. It is extremely slow. The Query is as follows :
SELECT * FROM TABLENAME ORDER BY VDate, TLN
I know it is the order by clause that is slowing the query down but I must have it in.
I have one expression index on my Table:
VDate is a Date field And TLN is a number field(10, 0)
Can anybody please help me speed up this query?