PDS Index Sorting

Question

Post reply

PDS Index Sorting

JonJon

Say Hey Kid

Points: 676
More actions
September 10, 2009 at 12:57 pm

#141514

Does it make any difference if my indexes are sorted in desc order to have the newest data at the top.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Adam Angelini SSCrazy Eights Points: 8548 More actions · Answer 1

I believe that would only affect order by clauses and sorting.

JonJon Say Hey Kid Points: 676 More actions · Answer 2

I should have been more specific. Would the retrival of data be quicker if the indexes were sorted in DESC order.

Adam Angelini SSCrazy Eights Points: 8548 More actions · Answer 3

It depends on the query and what you are sorting on. If you already have a particular query in mind, I would try it both ways and see what one is faster.