Developers can create a clustered index in Microsoft SQL Server databases. In a clustered index, the physical order of the rows in the table is the same as the logical (indexed) order of the index key values. A table can contain only one clustered index. When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to create a clustered index, they should follow the next steps:
1. In Object Explorer, right-click the table for which they want to create a clustered index and click Design (Modify in SP1 or earlier).
The table opens in Table Designer.
2. From the Table Designer menu, click Indexes/Keys.
3. In the Indexes/Keys dialog box, click Add.
4. Select the new index in the Selected Primary/Unique Key or Index list.
5. In the grid, select Create as Clustered, and choose Yes from the drop-down list to the right of the property.
The index is created in the database when they save the table.