Skip to main content
Share Your Experience: Take the 2024 Developer Survey
1 vote

Replace primary key with unique constraint and other clustered index to improve query performance without doubling table size

As mentioned in the comments by LoztInSpace, your primary key doesn't need to also be the clustered index. That is just the default (since most times it makes sense). But in a data warehouse ...
J.D.'s user avatar
  • 37.9k

Only top scored, non community-wiki answers of a minimum length are eligible