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

(Lyudmila Fokina) 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

Read More - Register for Free Membership