Create index in sql server

Two examples to create   indexes  in microsoft sql server 

              
                CREATE INDEX   index_name
ON  table_name (table field);

to create index with multiple fields 

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