Create index in sql server using t-sql

[Admin]

Today I want to give you an example of how to create a simple noncluster index using t-sql, and I always like to organize things when it comes to dealing with databases. As you can see I always set things to different files and file groups, so the reason for that is performance; I love to keep performance high.

CREATE INDEX IX_Name
ON DBINTSQL
(
   FirstName
 , LastName
 , Email
 , PhoneNumber
)
ON IXFILE
GO