Use the SQL Server View Index Editor to define a partition for a view 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 view index
The SQL Server View 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 view 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 View Index Editor closes.
Copyright © 2013 CA.
All rights reserved.
|
|