SQL Server

Create index in sql server

<p>Two examples to create&nbsp; &nbsp;indexes&nbsp; in microsoft sql server&nbsp;</p> <div id="gtx-trans" style="left:2px; position:absolute; top:-6px"> <div class="gtx-trans-icon">&nbsp;</div> </div>

1
2
3
4
5
6
7

CREATE INDEX   index_name
ON  table_name (table field);

to create index with multiple fields 

CREATE INDEX idx_MultipleFields
ON TableName (Field1, Field2, Field3);