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!

Calculate disk space needed for INDEX

guruparanApr 8 2010 — edited Apr 8 2010
Hi,

How to calculate disk space needed for creating an INDEX? Please point me to resources where I can get detail.

For Example:
I need to create an non UNIQUE INDEX on the following columns, a rough size would do.

<PRE>
EVENT_DATE NOT NULL DATE
APPT_DATE_SLOT VARCHAR2(15)
EVENT_STATUS VARCHAR2(4)
</PRE>

The table has some 7,300,000 rows. Let me know how to calculate too.

All helps are greatly appreciated.
This post has been answered by Mark D Powell on Apr 8 2010
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 6 2010
Added on Apr 8 2010
9 comments
4,455 views