And then there are table statistics or fragmented indexes that cause the optimizer to choose a different path. Even when you've done everything and you think t

And then there are table statistics or fragmented indexes that cause the optimizer to choose a different path. Even when you've done everything and you think the optimizer should choose a particular index it will surprise you.