To create an index, specify its name and main properties.

• "Unique" property means no two rows are permitted to have the same index value.
• "Clustered" creates an object where the physical order of rows is the same as the indexed order of the rows. A object is allowed only one clustered index at a time.