...is mostly already described here. I did get to see Mr. Cunningham himself speak to it all again at SQLSaturday. The new SQL tuning feature will record a history of all plans and let you just fall back to that one that used to work when things start choking on a new plan. The one thing I heard that was new that I had not heard before was that "The Optimizer" is one is one big algorithm which runs like a chess program. This behemoth tries to come up with the best plan for you the same way that Deep Blue tried to win at chess.
No comments:
Post a Comment