Sign in
Tips, Tricks, and Advice from the SQL Server Query Processing Team
The query processing team - query optimization & execution - providing tips, tricks, advice and answers to freqeuently-asked questions in a continued effort to make your queries run faster and smoother in SQL Server.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Tags
Compilation time
data warehousing
Distinct aggregation
Estimate Rows
ETW
Hash Join
Indexing
Memory Management
OLAP
OLTP
optimizer
Query cost
query memory
query optimization
Query plan
Showplan
Showplan_XML
SQL Profiler
SQL Server 2005
SQL Trace
Star Join
Statistics Profile
Statistics XML
Tracing
Archive
Archives
March 2010
(1)
February 2010
(1)
August 2009
(1)
September 2008
(1)
June 2007
(1)
May 2007
(2)
April 2007
(1)
February 2007
(1)
January 2007
(2)
December 2006
(2)
November 2006
(6)
October 2006
(5)
September 2006
(4)
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Tips, Tricks, and Advice from the SQL Server Query Processing Team
Index Build strategy in SQL Server - Part 2: Offline, Parallel, No Partitioning (Non stats plan (no histogram))
Posted
over 7 years ago
by
SQL Server Query Processor Team
0
Comments
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...
Tips, Tricks, and Advice from the SQL Server Query Processing Team
Index Build strategy in SQL Server - Part 2: Offline, Parallel, No Partitioning
Posted
over 7 years ago
by
SQL Server Query Processor Team
1
Comments
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 ...
Page 1 of 1 (2 items)