And might I add, it was odd seeing my name as a topic. Ha!

I try to use lanyrd.com to track upcoming events. I think I'm a little behind on that at the moment. I do post upcoming events on my blog as well....

Joy Smith San (10/16/2014)

---

Thank you.

So if I have multiple unwanted indexes, obviously...

The other option is to simply throw hardware at the problem, but that's very expensive and of limited utility. You're going to have to convince people about the realities of...

I'd raise a stink internally. You can't work miracles. There are physical limitations to the universe and a query without a WHERE clause is going to smack right into them...

Random or not, they're ugly to read.

If updating the indexes doesn't work, try updating the statistics, possibly with FULL SCAN.

Possibly a change in indexes? Statistics are out of date or missing? Check the execution plan. It sure sounds like the optimizer is making some poor choices in executing this...

I've got nothing either. You'd think, logically, adding additional AND logic would result in further filtering, not the addition of more data.

I don't know of any mechanism of code enforcement at the server that you could do to make this happen. Sorry.

It must be a hash of some kind based on the server. I got different values than you did. And, if I dropped the table and recreated it, I got...

The size of the indexes is much more of a question than the number of them.

TheSQLGuru (10/15/2014)

---

Grant Fritchey (10/15/2014)

---

TheSQLGuru (10/15/2014)

---

GilaMonster (10/15/2014)

---

And an extended events session...

What he said.

And, you know where to go if you get stuck.

BOR15K (10/15/2014)

---

Apologies for the complete blunt question.

I have created Countries_View and placed the problematic CASE within the view and then JOINT Cities A table with Countries_View B

and all works like...