THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
Performance impact: UNION ALL views, ANSI_PADDING, and bad query plans
Whether 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 simple example. Assume that you have this simple view with a UNION ALL ...
December 4, 2009
Brought to you by