Help on ORDER BY

Hello,

    I have a table with a unique index defined on the column 'entryid' and a non unique index defined on the column 'timstamp'.

If I do

     select * from table order by entryid it works very fast.

If I do

     select * from table order by timstamp it takes about 4 minutes to get the first record on a 100,000 records table.

Any ideas ?

Terry Received on Mon Dec 14 1998 - 01:22:48 CST