http://sqlblog.com/blogs/linchi_shea/archive/tags/Performance+tuning/Optimizer+Bug/default.aspxTags: Performance tuning, Optimizer BugenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/linchi_shea/archive/2009/12/04/performance-impact-union-all-views-ansi-padding-and-bad-query-plans.aspxFri, 04 Dec 2009 19:43:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19514Linchi Shea6http://sqlblog.com/blogs/linchi_shea/comments/19514.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=19514Whether or not you specify it explicitly, ANSI_PADDING setting is there when you create a table, and can have an impact on the performance of some queries. If you are not careful, it can even hurt performance big time! Let’s demonstrate that with an extremely...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2009/12/04/performance-impact-union-all-views-ansi-padding-and-bad-query-plans.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=19514" width="1" height="1">Optimizer BugPerformancePerformance tuningQuery Processing