This blog show how to create an index in a table

Syntax:

CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX indexname
ON {
[ databasename. [ schemaname].| schemaname. ]
table or viewname}
(column [ ASC | DESC ] [ n ])