Solved

how to reduce the size of the indexes in SQL Server

Posted on 2009-06-30
4
543 Views
Last Modified: 2012-05-07
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
Comment
Question by:shadyc
  • 2
4 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24749847
- you can drop some unused indexes
- do an index defragmentation
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24749857
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
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 24749999
0
 

Author Comment

by:shadyc
ID: 24750070
Thanks for helping me...I'll look in to it and get back to you
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question