Subhash Sharma

Subhash Sharma
Subhash Sharma

This is Subhash Sharma(Software Engineer) Blog

Welcome to this blog and find every solution.............

Search This Blog

Software Engineer(Subhash Sharma)

Software Engineer(Subhash Sharma)
Software Engineer
Showing posts with label Index in sql server. Show all posts
Showing posts with label Index in sql server. Show all posts

Friday, March 26, 2010

Index in sql server

//Important thing to note: By default a clustered index gets created on the primary key
and where are unique creates a nonclustered index by default

CREATE clusteredINDEX myIndex ON myTable(myColumn)