• Questions

    Clustered index vs Non clustered index

    Clustered index vs Non clustered index structure Clustered and Non clustered indexes are stored in a B – tree structure . Clustered Index Clustered index enforce the logical order. (Misconception: Clustered index does not enforce the physical order)   A table has only one clustered index because, the original table stored at the leaf level of the clustered index (Data pages).   When you create a primary key by default clustered index will be created internally. (If the table has clustered index already then the non clustered index will be created internally)   If the table does not have clustered index it’s called “Heap” Non Clustered Index Non clustered indexes…