This is a enormous question. A single clustered index can be created on a table and this index physically sorts the data for the entire table based on the values in this column. A table can have up to 255 non clustered indexes. Non clustered indexes are based on order of the data, but do … Read more