Softlogger
Categories

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…

Filed under: Database,SQL  |    On : 2006 Dec 11  |  From: SQL Query Processing Team   | related Posts

Similar Posts



Most Popular

Archives

  • 2008
  • 2007
  • 2006
  • 2005
  • 2004
  • 2003