Name the different type of indexes in SQL Server?

devquora
devquora

Posted On: Feb 22, 2018

 

There are three types of indexes in SQL

  • Unique - this index helps to maintain the Data integrity by ensuring that there is no repetition in the two identical values. This reputation might be the data in a table or in any other database record. It maintains the value of index keys as unique.
  • Clustered index - clustered index records all of the physical values of the table and database which are entirely based on the key values. Over each table, there will be a single clustered index.
  • Non clustered index - this index does not alter the physical value from any segment. Each table under this can have a 999 non clustered indexes in a logical order.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    SQL Server Interview Questions

    What are a database and a data warehouse?

    A database, in general, is a collection of information in a more organized form for better access...

    SQL Server Interview Questions

    What is normalization according to you and explain its different levels?

    In order to remove the redundant data, normalization is used. It also reduces the null values and enables the efficiency of indexing...

    SQL Server Interview Questions

    What do you understand by the denormalisation?

    Denormalization is the inverse process of normalization...