Create index in sql server using t-sql

Go down

Create index in sql server using t-sql

Post by Admin on Thu Feb 20, 2014 4:17 pm

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
avatar
Admin
Admin

Posts : 9
Join date : 2013-10-16
Age : 33

View user profile http://forensicsblog.forumotion.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum