# Estimate the Size of a Table

**APPLIES TO:** SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse

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

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.

For each nonclustered index, calculate the space required for it by following the instructions in Estimate the Size of a Nonclustered Index.

Add the values calculated in steps 1 and 2.

We are listening:If you find something outdated or incorrect in this article, such as a step or a code example, please tell us. You can click theThis pagebutton in theFeedbacksection at the bottom of this page. We read every item of feedback about SQL, typically the next day. Thanks.

## See Also

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

## Feedback

Loading feedback...