Primary Key and Database Size

Why does inclusion of a PK in each table of a database help to reduce the overall size of the database?

I had a trial database with lots of tables, one I put in PKs for every table, the size of the database shrank

Sanjay
kalraniAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
If there is NO primary key, SQL Server will take internally the entire record columns to identify the rows, which does take of course much more space that a single column...

CHeers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.