Thanks for all the replies.

I will do the following:

1. Do a test from code prior to making any index changes with both queries to see which one runs faster.

2. Once...