For effective clustered indexes, follow the few basic points below.
- Narrow – as narrow as possible, in terms of the number of bytes it stores
- Unique – to avoid the need for SQL Server to add a "uniqueifier" to duplicate key values
- Static – ideally, never updated
- Ever-increasing – to avoid fragmentation and improve write performance
For full detailed explaination, read