distal-attribute
distal-attribute
distal-attribute
distal-attribute

Showing huge DB size with index - how to reduce ?

User, date Message
Written by Thiru
9 months ago
Category: General
8 posts since Sat, 28 Dec 13
Hi,
When i use index in all columns my DB size gets huge.
How to reduce it?

i have a table with 8 column and all the columns are indexed.
no. of available records (rows): 2,25,000
its size is: 526.9MB
my total DB size is 1GB

Let me know how to reduce the DB size.
I hope the size gets huge due to indexing - am i right ?
pls. confirm me in this regard.
and get me a solution to reduce the DB size.

Expecting your valuable reply.
Thanks & Regards,
Thiru.
Written by ansgar
9 months ago
5012 posts since Fri, 07 Apr 06
Yes, indexes can get quite huge, especially if they were applied to text columns. How to reduce that? Delete unused indexes. If you use and need all of them, don't care about the overall size of your database - it's not that relevant for performance.
Written by Thiru
9 months ago
8 posts since Sat, 28 Dec 13
Okay thanks for your quick reply.
 

Please login to leave a reply, or register at first.