• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 565
  • Last Modified:

how to reduce the size of the indexes in SQL Server

I have a database of size 100gb.When I tried to see the disk usage the size of the index is more than data size.Pls see the attached screen shot.
Iam running out of disk space and Iwant to reduce that index size.
Pls help

Thanks
inde.GIF
0
shadyc
Asked:
shadyc
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
- you can drop some unused indexes
- do an index defragmentation
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you must have created plenty of (eventually unusable) indexes.
you need to double-check each of the indexes if it is really used, and if not, drop it.

note: if the indexes graph includes the clustered indexes, those are actually containing the data of the table itself also...
0
 
shadycAuthor Commented:
Thanks for helping me...I'll look in to it and get back to you
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now