What is difference between clustered index and non clustered index?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

Difference between clustered index and non clustered index

  • Cluster index is an index type that is used to sort table data rows on the basis of their key values. In RDBMS primary key allows us to create a clustered index based on that specific column.
  • A non-clustered index (or regular b-tree index) is an index where the order of the rows does not match the physical order of the actual data. It is instead ordered by the columns that make up the index.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Mssql Interview Questions

    What is MSSQL?

    MSSQL stands for Microsoft Server SQL that is a Microsoft’s relational database management system. It is a featured d..

    Mssql Interview Questions

    What is SQL server agent and what are the two modes of authentication in SQL Server?

    SQL Server agent The SQL Server agent plays an important part in the day to day tasks of the SQL Server Database Admini..

    Mssql Interview Questions

    What is SQL Profiler?

    It is a tool that allows system’s administrator to monitor the events in SQL Server.It is mainly used to capture and ..