Dimitry, and Ann,

Thanks for responding and for your advice.

I currently do select a subset of data using select and use ORDER BY to order the data. But before I release my web application, I want everything to be as efficient as possible and don't want the database to have to order tables each time a user chooses to order data differently.

I only want to create an index on a few important fields that will be regularly ordered by web visitors.

And I really do want to allow both ascending and descending orders. This being the case, should I create two indexes for my example timestamp field in both ascend and descend order?

Thanks again?