Can I define an index for a select statement.

Primary key - InvoiceNo
Secondary key - InvoiceNo,InvoiceDate

20,000 records

select * from Invoice - 3 seconds

select * from Invoice - 22 seconds
order by InvoiceDate

if the second query used the secondary index it should be faster as they'd be ordered already.
Can I select the index? Whats my problem please help. Received on Fri Mar 05 1999 - 11:45:52 CST