Educational

Indexes (Clustered vs Non-Clustered)

Written by

Saim Khalid

in

    • Index → improves query speed (like book index).
    • Clustered Index → sorts and stores rows physically in table. (Only one allowed).
    • Non-Clustered Index → separate structure pointing to data. (Many allowed).

    Comments

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    More posts