The Disk Space Analysis Report shows the space estimate to store the recommended indexes.
This information is helpful in databases where space is a factor. You may see performance improvements by using the recommended index, but it may take up too much space.
This report is created after a workload is analyzed.
The following table explains the information provided by this report.
|
Column Name |
Description |
|
Analysis Type |
Shows the type of analysis |
|
Database Name |
Shows the name of the database used to generate the report. |
|
Table Name |
Shows the name of the table. |
|
Index DDL/ Expression Text |
Indicates the index definition. |
|
Size (KB) |
Provides the estimated size of the index in kilobytes. |