Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2008 Property Editors › Define a Table Index in SQL Server 2008 › Define Options for a SQL Server 2008 Table Index

Define Options for a SQL Server 2008 Table Index

Use the SQL Server Table Index Editor to define advanced options for table indexes in a SQL Server 2008 physical model.

To define options for a table index in SQL Server 2008

1. Right-click a table index in the Model Explorer and click Properties.

   The SQL Server Table Index Editor opens.

2. Select the table from the Table drop-down that contains the index that you want to define.
3. Select the index in the Navigation Grid that you want to define.

   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 options.

4. Click the Options tab and work with the following options:

   Fill Factor

   Specifies the fill factor property for the current index type. Enter a value in the field.

   Pad Index

   Specifies the pad index value for the current index type. Select the option from the drop-down.

   Sort In Temp DB

   Specifies the sort in temporary database value for the current index type. Select the option from the drop-down.

   No Recompute

   Specifies the no recompute value for the current index type. Select the option from the drop-down.

   Drop Existing

   Specifies whether to use the drop existing option. Select the option using the check box.

   Allow Row Locks

   Specifies the allow row locks value for the current index type. Select the option from the drop-down.

   Allow Page Locks

   Specifies the allow page locks value for the current index type. Select the option from the drop-down.

   Maximum Degree of Parallelism

   Specifies the maximum parallel property for the current index type. Enter a value in the field.

   Ignore Duplicate Keys

   Specifies the ignore duplicate keys value for the current index type. Select the option from the drop-down.

   Online

   Specifies the online value for the current index type. Select the option from the drop-down.

   Filegroup

   Specifies the file group to which the index belongs. Select a file group from the drop-down.

   Filestream Partition Scheme

   Specifies the partition scheme used to store filestream data for a partitioned index.

   Filestream Filegroup

   Specifies the filegroup utilized to store filestream data for a non-partitioned index.

5. Click Close.

   Options are defined for the table index and the SQL Server Table Index Editor closes.