I need a short explaining of clustered index.
- What is a clustered index?
- What are best practices for using the clustered index?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
In simple terms...
A telephone directory: the data is the index/the index is the data. To look you up, I'd start with Rezaei, Amir for example. No external lookup is needed.
In database terms:
The table data and clustered index are one and the same (in SQL Server, also InnoDB, Oracle IOT)
Best practice is narrow, numeric, strictly increasing (think IDENTITY or Autonumber column). Data types like GUIDs are not a good idea
Links to read (to avoid bloating this answer)
Edit, to fully explain my best practice suggestions, follow the link in Eric Humphrey's comment: Queen of Indexing: Kimberly Tripp