Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why Index size is bigger than table size?

542428Apr 7 2010 — edited Apr 7 2010
Dear All,

I found in my database my tables sizes is coming around 30TB (All Tables in Database). and my index size for the same is 60TB. This is data ware housing environment.

How the index size and table size are differing?

Why they are differing? why index size is bigger than table size?

How to manage the size?

Please give me clear explanation and required information on the above.

Regards
Suresh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2010
Added on Apr 7 2010
4 comments
6,741 views