I believe when I create an identity column it gets indexed automatically, but I'm not 100% sure.

Should I create an index for an identity column, or is it created automatically?

sql-server indexing identity
Edit
Report