Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Partitioned tables Expand / Collapse
Posted Thursday, February 21, 2013 3:28 AM


Group: General Forum Members
Last Login: Today @ 2:13 AM
Points: 424, Visits: 1,719

Create table Table1 (ID INT P.K, OrderDate Date))
1. The table has clustered index on ID.

Afterwards we have partitioned the table based on OrderDate. What it will do is the specified rage data keep in mentioned FG.

Is there any difference in partioned / non-partitioned tables Clustered index architecture.

Post #1422476
Posted Thursday, February 21, 2013 3:34 AM



Group: General Forum Members
Last Login: Tuesday, July 19, 2016 4:34 AM
Points: 2,850, Visits: 4,076
from BOL

Although partitioned indexes can be implemented independently from their base tables, it generally makes sense to design a partitioned table and then create an index on the table. When you do this, SQL Server automatically partitions the index by using the same partition scheme and partitioning column as the table. As a result, the index is partitioned in essentially the same manner as the table. This makes the index aligned with the table.

SQL Server does not align the index with the table if you specify a different partition scheme or a separate filegroup on which to put the index at creation time.

Aligning an index with a partitioned table is particularly important if you anticipate that it will expand by taking on additional partitions, or that it will be involved in frequent partition switches.

I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1422479
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse