Welcome to MSDN Blogs Sign in | Join | Help

December 2006 - Posts

Wednesday, December 13, 2006 11:55 AM

Index Build strategy in SQL Server - Part 2: Offline, Parallel, No Partitioning (Non stats plan (no histogram))

Build (serial) (write data to the in-build index) | X (Merge exchange) / | \ Sort… Sort… Sort … (order by index key) | | | Scan… Scan… Scan… (read data from source) When histogram is not available (for example when we building an index on a view) we can’t
Posted by queryproc | 0 Comments
Filed under:
Monday, December 11, 2006 3:07 PM

Index Build strategy in SQL Server - Part 2: Offline, Parallel, No Partitioning

The type of parallel index build plan in SQL server depends on whether or not we have a histogram available with necessary statistics. Therefore, there are two broad categories of parallel index plans: Histogram available: No histogram Histogram available
Posted by queryproc | 1 Comments
Filed under:
 
Page view tracker