Use the SQL Server Table Index Editor to define a partition for a table index in either a SQL Server 2005 or 2008 physical model. You need a column to partition the index on, a scheme to determine where the partition resides, and a partition function to define the boundary of the partition.
To define a partition for a SQL Server table index
The SQL Server Table Index Editor opens.
Note: Use the Enter filter text box to filter a very large list of indexes to quickly locate the one for which you want to define a partition.
Specifies the column upon which to partition the table index. Select the check box to specify the column.
Specifies the scheme that defines the partition boundaries and the filegroups in which the partition resides. The Scheme '<index_name>' Filegroups field displays the scheme's partition boundary and the list of filegroups to store the partitions.
The partition is defined and the SQL Server Table Index Editor closes.
Copyright © 2013 CA.
All rights reserved.
|
|