16. Calculating Disk Space : Space Requirements for Tables : Calculate Space Requirements When Rows Span Pages
 
Share this page                  
Calculate Space Requirements When Rows Span Pages
Follow these steps to determine the amount of space needed to store the data in a table with rows that span pages:
1. Determine the number of pages per row, as follows:
pages_per_row = row_size / max row size
where max_row_size is the maximum row size for the table, as shown in Maximum Row Size Per Page Size (see page Maximum Row Size Per Page Size).
Round up to the nearest integer.
2. Determine the number of data pages needed for the table, as follows:
data_pages = num_rows * pages_per_row