(Naomi Said ) > In SQL Server Index can be used for ORDER BY.

So, as I prepare my tables to be upsized to Sql Server, you're saying that I should plan on having an index in place for cases where I will use the Order By clause?

I use Order By a lot, since all my child records have a field named 'Item' that I used in the Order By clause to get the child records in the correct order when they are displayed in the grid. The user can then rearrange them un the UI, and that's where the Item field comes in.

You're saying and index will help that a little? The result set of child records is usually less than 10 records, so I've always assumed that ordering them by their 'Item' field was so easy/fast that there was no need to have an index in place.

What do you think about this for my case?