Time for action – Adding an index using the designer
In this exercise, we want to add an index to the
Products table. In our ordering system, we want to have the possibility to search for products by name. To make this search fast, we define an index for the Name column.
- In SSMS, locate the Products table in the Object Explorer.
- Right-click on the Products table and select Design. The designer for the Products table will open in a new tab.
- Right-click on any of the columns in the Products designer and select Indexes/Keys…, as shown in the following screenshot. The Indexes/Keys... dialog window will open.
- Click on Add to add a new index and set the ...