Wednesday, March 21, 2012

Index Order

In my application for the most part we Usually work with the Most Recent Data. If I am indexing on a AutoNumber Field and I set the Order to Descending would that cause it to find my data faster?

Well, that would naturally depend on all the other factors.

But, changing the order of the sort on the index shouldn't affect the data access, as the index is a B-Tree.

It will run the chain in which ever path is needed. Reversing the order will just send it to the left instead of the right.

What fields you have in your index in regards to meeting the needs of the query are more important.

No comments:

Post a Comment