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…

0

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 (parallel sort and build):                  X (Exchange)    |          \            \          Builder……

1