Of a Table

Analytics Platform System (PDW)

SQL database in Microsoft

Fabric

You can use the following steps to estimate the amount of space required to store data in a

table:

1. Calculate the space required for the heap or clustered index following the instructions in

Estimate the size of a heap

or

Estimate the size of a clustered index.

2. For each nonclustered index, calculate the space required for it by following the

instructions in

Estimate the size of a nonclustered index.

3. Add the values calculated in steps 1 and 2.

Estimate the size of a database

Estimate the size of a heap

Estimate the size of a clustered index

Estimate the size of a nonclustered index