>So to restate my question, is there anything I'm missing that could result in the better plan without forcing it with NOEXPAND?
Apart from ensuring that the appropriate indexes and statistics are in place, it's very dependent on the details of the query.
If you look at the actual execution plan from the un-hinted plan, are the any estimates that are way off?
David
David http://ift.tt/1c5QNcs
No comments:
Post a Comment