0

I wanted to know whether the storage overhead per row in atable is fixed for all tables created irrespective of given datatypes or it varies from one table to another?

1 Answer 1

0

The table row layout describes a header of 23 bytes for each table row, and that is independent of the data types.

One item that is variable is the “null bitmap” that is technically part of the row data: it is only present if there is a nullable column in the table. Yet another reason to define most columns as NOT NULL!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.