You have created a table with the columns shown in Table 4-3. Approximately how much space does this table require on disk if it has 1,000,000 rows?

You have created a table with the columns shown in Table 4-3. Approximately how much space does this table require on disk if it has 1,000,000 rows?

You have created a table with the columns shown in Table 4-3. Approximately how much space does this table require on disk if it has 1,000,000 rows?


Answer – 144 MB

(A record in this table is 131 bytes long with 3 bytes of null bitmap space and a 4-byte row header, which equates to 57 records per page. At 1,000,000 records, that is 17,544 pages (1,000,000 ÷ 57 rounded up). Multiply 17,544 by the full size of a page (8,192 bytes with overhead), and you get 143,720,448, or approximately 144 MB.)