Estimate the Size of a Table
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
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.
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
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for