New answers tagged clustered-index
The reason why you don't see much of benefit is because of the LIKE clause on column CODE. The optimizer would, in general, will not prefer such columns. The optimizer cannot directly resolve such types of queries/clauses. I would suggest you to have an index on column CompanyId alone and see if that helps. Good luck!
No way to seed it. That whole "globally unique" part gets in the way. the bigger question here is "do you truly require this?" GUIDs are big, GUIDs -even with newsequentialid, can lead to index fragmentation. If you need GUIDa where do you need them? They typically do not make great clustered index candidates. For both of these reasons and more.
Top 50 recent answers are included