Improving performance of cluster index GUID primary key

Question

I've a table with large number of rows (10K+) and it primary key is GUID. The primary key is clustered. The query performance is quite low on this table. Please provide suggestions to make it efficient.

Answer 1

You need to use newsequentialid() instead see here Some Simple Code To Show The Difference Between Newid And Newsequentialid