Introduction:
When
create table and set Primary key, an index will be created automatically. But
we can also set index manually.
I this article I will explain how to create index on column in or create index on
multiple columns in sql
server or create index on
table in sql server 2008 with example.
Create Index
on Single Column:
Syntax to Create Index
CREATE INDEX indexname ON Tablename(columnname)
Example:
CREATE INDEX IC_Empid ...