I forgot to mention... I also have an index on RowNum that includes all the fields I am selecting; with or without the index hint my query is 1. getting the RowNums and 2. using the RowNum index to get all the other fields. Please let me know if other info would be helpful.

Thanks for any advice!

Tai