>>>>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?
>
>Your call. Multiple indexes never really bothered me unless I had to make changes to them. What's the odds you'll need to change what fields they are on?
The odds of changing table structure are slim (except for probably adding more fields). However, the more indexes we have, the more chances for corruption, IMHO.
If it's not broken, fix it until it is.
My Blog