Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srivatsahg
Yak Posting Veteran
71 Posts |
 Posted - 2009-07-28 : 06:42:45
|
| Hello ForumMy application database has a very big table with 8 different Non-Clustered Indexes associated with it.I used sql server reporting services to view the disk space usage statistics for this table. From what i observe from the statistics is that the indexes for this particular table occupies more space than the data itself.Is this a normal scenario ??If this is not, any particular suggestions in this directionVatsa |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-07-28 : 08:04:01
|
| It would help if you posted the table structure and the indexes on it.You should run DBCC UPDATEUSAGE on that table and then look at the report again. If the table had a lot of delete or update activity, the index allocations may be out of sync with the actual space used. |
 |
|
|
|
|
|
Disk usage of Indexes