No problem Drew. Personally I would leave your current indexes in place, but add additional ones with the different column order and see if they improve performance for specific queries. That way you don't risk anything by changing an existing index, you supplement it by adding extra ones, certainly until you determine which ones actually work best, maybe all of them though. You only have 2 at present anyway so adding a third or fourth is not an issue.

You can then monitor how often each index is being used. You may find they are all used, each supporting different queries. If a particular one is not being used you can then remove it. On a large table the overhead of maintaining an extra couple of indexes is insignificant compared to the overhead of table scanning because they don't exist. Just ask a user waiting for the query to return when it's table scanning 62 million rows :w00t:

Cheers

Roddy