Home » RDBMS Server » Server Administration » Index sizing
Index sizing [message #369179] Wed, 05 April 2000 16:20 Go to next message
Messages: 255
Registered: April 2000
Senior Member

Anybody has any idea regarding how much space require to create an index (unique/non-unique), any formula for calculating this? I derived one formula from a table, with column size (using vsize/lenghtb), rowid. But I don't think mine is right, because I got different values for different tables.
I will appriciate if anyone can give me some idea regarding this matter.
thank you
Re: Index sizing [message #369181 is a reply to message #369179] Wed, 05 April 2000 17:20 Go to previous message
Messages: 17
Registered: December 1999
Junior Member
At the appendix of the "Oracle server administrator guide", there is a chapter talked about the space estimations for schema objects. It will show you how to estimate space for indexes. Actually, you can put this formula into EXCEL spreadsheet and put in estimate number of records, then you can size your indexes, tables, or the whole database.
Previous Topic: Upgrade Oracle database
Next Topic: nvarchar2
Goto Forum:

Current Time: Sun Nov 27 19:19:37 CST 2022