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
shadycAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.