Join Adam Wilbert for an in-depth discussion in this video Creating a nonclustered index in SSMS, part of Database Foundations: Storage.
There are two ways that we can add…nonclustered indexes onto our tables.…Let's take a look at how we can do it using…the Graphical User Interface inside of Management Studio.…First, I want to find a specific table,…this Product Listing table, I am going to…right click on it and choose Select Top 1000 Rows.…That will show me the data that is…currently inside of this table.…Now in this table, I have a Product ID column,…this is the primary key for the table,…so there is already a clustered index…being applied to this field here.…What I want to do is create a nonclustered index…based off of the item field, because this is a field…we might want to search on regularly.…
Let's go ahead and close this tab down and…I'll expand the product listing table and…then take a look inside of the indexes folder.…You can see that, indeed, we do have a…single clustered index based off of…the primary key field of this table.…In order to add in a new nonclustered index,…I can right-click on it, go to New Index,…and then choose new Non-Clustered Index, right here.…
Note: This course will also prepare certification candidates for the "Understanding data storage" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals. Find out more at https://www.microsoft.com/learning/en-us/exam-98-364.aspx.
- Reducing redundancy with normalization
- Fixing partial dependencies
- Creating primary keys
- Linking tables with foreign keys
- Creating clustered and nonclustered indexes