Lynn Pettis (5/4/2015)

---

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something like:

Please help me fix this poorly performing query, but without any code changes.

So how am I supposed to help? Maybe with some indexing tips, but, in my opinion, that's a code change.

Sometimes, improving the indexing is the only option available. Supporting a product where most of the code is embedded in the code and requires approval to make changes, then needs to go through extensive testing and approval processes, you do what you can where you can.