>>I found the difference in indexes. One is in ascending order and one is in descending. They are used in the code - so not easy to get rid of them.
>>Not sure why it was programmed this way.
>
>You can just SET ORDER TO [TAG] DESCENDING and SET ORDER TO [TAG] ASCENDING. You don't need two different indexes.
I know that - but it seems to be in too many places. Or should I take the bullet here?
If it's not broken, fix it until it is.
My Blog