How is the table size determined

__ __2
Tera Expert

Hi.

 

Is the table size only determined by the number of records?
Or are there other factors that determine the table size?

5 REPLIES 5

Vasantharajan N
Giga Sage
Giga Sage

Table Size is calculated based on  no of records [number of columns/fields, type of column/field], indexes on the table.


Thanks & Regards,
Vasanth

Are deleted records included?

No. Deleted records won't exist in the table. 

For Example, Assume you have table x and it has 100 rows of data. Assume each row in the table of size 1 MB then the table x size is going to be 100 MB. if you delete one record from the table x then the total size will become 99 MB.


Thanks & Regards,
Vasanth

Community Alums
Not applicable

Hello @Vasantharajan N , thanks for the insight, do we know how SN calculates the row size? if there is any scripting function for the same?