| Index sizing [message #369179] |
Wed, 05 April 2000 16:20  |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
hi,
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
sam
|
|
|
|
| Re: Index sizing [message #369181 is a reply to message #369179] |
Wed, 05 April 2000 17:20  |
Cpchin
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
