From the course: SQL Server 2014 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Creating an index

Creating an index - SQL Server Tutorial

From the course: SQL Server 2014 Essential Training

Start my 1-month free trial

Creating an index

- Now I'll demonstrate creating an index. Here in Management Studio, I'm gonna open up AdventureWorks2014 Database. And then I'll open up Tables. And we're gonna look at HumanResources.Employee, that's a table we've worked with before. Open that up, and underneath it one of the items is Indexes. If we open that up, we see a handful of indexes already created. I'd like to create a new one. I can just right-click on Indexes and the top item is New Index. And then it'll ask me for the type, I'm gonna go with a Non-Clustered Index. In the interface that comes up, it has a field for Table name, which I can't change. It's greyed out. So the table has already been decided, it will on the employee table. Then it has a field for Name, and it defaulted to a name that I'm gonna keep. You could change the name if you like. Then it's asking me for the columns. So I'll click Add. And I'm just gonna add one column for this one, the BirthDate column, and click OK. And it's saying it's going to put it…

Contents