Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Indexing   (RSS)
Sorry, but there are no more tags available to filter with.
Sunday, May 13, 2007 9:15 PM

Index Build strategy in SQL Server - Part 4-2: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)

Source Partitioned While the table is partitioned, we may want to change the way it is partitioned when building the new index. For example, by using the same partition function and scheme, the new index can be partitioned on different columns than the
Posted by queryproc | 1 Comments
Filed under:
Tuesday, May 08, 2007 11:56 AM

Index Build strategy in SQL Server - Part 4-1: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)

Recall that in the previous posts on index build, we defined "aligned" as the case when base object and in-build index use the same partition schema, and "non-aligned" to be the case when heap and index use different partition schemes, or the case when
Posted by queryproc | 1 Comments
Filed under:
Friday, January 19, 2007 5:20 PM

Index Build strategy in SQL Server - Part 3: Offline Serial/Parallel Partitioning (Aligned partitioned parallel index build)

Aligned partitioned parallel index build In case of parallel build we scan and sort partitions in parallel and the actual number of sort tables existing at the same time will depends on the actual number of concurrent workers. Partitions are being chosen
Posted by queryproc | 0 Comments
Filed under:
Tuesday, January 16, 2007 3:27 PM

Index Build strategy in SQL Server - Part 3: Offline Serial/Parallel Partitioning

There are two main categories of partitioned index build: Aligned (when base object and in-build index use the same partition schema) Not- Aligned (when heap and index use different partition schemas (including the case when base object is not partitioned
Posted by queryproc | 0 Comments
Filed under:
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 | 0 Comments
Filed under:
Monday, November 20, 2006 1:19 PM

Index Build strategy in SQL Server - Part 1: offline, serial, no partitioning

Builder (write data to the in-build index) | Sort (order by index key) | Scan (read data from source) In order to build the b-tree for the index we have to first sort the data from source. The flow is to scan the source, sort it (if possible - in memory*),
Posted by queryproc | 0 Comments
Filed under:
Thursday, November 09, 2006 4:05 PM

Index Build strategy in SQL Server - Introduction (II)

- Building Partitioned Index vs. Building non-Partitioned Index: The data of partitioned tables and indexes is divided into units that can be spread across more than one filegroup in a database. The data is partitioned horizontally, so that groups of
Posted by queryproc | 1 Comments
Filed under:
Wednesday, November 08, 2006 3:05 PM

Index Build strategy in SQL Server - Introduction (I)

Index Build strategy in SQL Server may vary depending on users needs. Each of these Index Build strategies may have different memory and disc space requirement. These different strategies will be discussed in the next several posts. For the beginning
Posted by queryproc | 1 Comments
Filed under:
 
Page view tracker