O'Reilly logo

NHibernate 3 Beginner's Guide by Gabriel N. Schenker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

  1. In SSMS, locate the Products table in the Object Explorer.
  2. Right-click on the Products table and select Design. The designer for the Products table will open in a new tab.
  3. 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.
    Time for action – Adding an index using the designer
  4. Click on Add to add a new index and set the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required