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