Hi, Thanks Elliott.

I just did the following in a test environment (same amount of records).

Drop the primary key constraint.

Recreate the (non clustered) primary key.

Create a clustered index on the field...

Its pretty wide table with 10 columns taking about 250 bytes per record.

(Sorry for duplicate posting, got error messages and after 2 try I realized there were multiple posts)