C# web using linq

In Object Explorer, click the plus sign to expand the database that contains the table on which you want to create an index with nonkey columns.

Click the plus sign to expand the Tables folder.

Click the plus sign to expand the table on which you want to create an index with nonkey columns.

Right-click the Indexes folder, point to New Index, and select Non-Clustered Index….

In the New Index dialog box, on the General page, enter the name of the new index in the Index name box.

Under the Index key columns tab, click Add….

In the Select Columns from table_name dialog box, select the check box or check boxes of the table column or columns to be added to the index.

Click OK.

Under the Included columns tab, click Add….

In the Select Columns from table_name dialog box, select the check box or check boxes of the table column or columns to be added to the index as nonkey columns.

Click OK.

In the New Index dialog box, click OK.

Or if you use T-SQL,

USE AdventureWorks2012; GO -- Creates a nonclustered index on the Person.Address table with four included (nonkey) columns.  -- index key column is PostalCode and the nonkey columns are -- AddressLine1, AddressLine2, City, and StateProvinceID. CREATE NONCLUSTERED INDEX IX_Address_PostalCode ON Person.Address (PostalCode) INCLUDE (AddressLine1, AddressLine2, City, StateProvinceID); GO


Please visit the following URLs which would be more useful and might help you:

http://msdn.microsoft.com/en-us/library/ms191241(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms190806.aspx

Please feel free to ask if you have still questions on this.