0 down vote favorite
I have a large table with around 19 Million records in it.
The primary key is a unique identifier column called ID (data type is unique identifier NOT int) and there is a non clustered index setup on this ID column.
The table currently has no Clustered Index on it.
I am considering changing this column from a non clustered index to a clustered index since the table currently has no clustered index but am wondering what are the pros and cons of doing this or if I should.
- Leave things as is
- Find another column to create the clustered index on
- Change this ID column over from a non clustered index to a clustered index.
If anyone can give me some guidance as to what are some considerations for making this decision, I would appreciate that greatly.
Thanks in advance,