Home » Developer & Programmer » Forms » Oracle - Table Indexes - Storage Clause
Oracle - Table Indexes - Storage Clause [message #375335] Wed, 09 August 2000 03:33 Go to next message
Thomas Guiot
Messages: 1
Registered: August 2000
Junior Member
Dear all,

Does anybody know a reliable way to calculate the storage clause when you create new tables and indexes.

Thanks in advance.

Thomas
Re: Oracle - Table Indexes - Storage Clause [message #375337 is a reply to message #375335] Thu, 17 August 2000 09:33 Go to previous messageGo to next message
JOHN
Messages: 182
Registered: April 1998
Senior Member
You might try total number of characters for a fully populated row * the estimated number of rows. This will give you an estimate of the space required for the table.

As for indexes you might try max(length(index key)) * number of estimated rows.

Get with your DBA for any intial extents and next extent sizing and pctincrease requirements at your site.

Hope this helps.
Re: Oracle - Table Indexes - Storage Clause [message #375338 is a reply to message #375335] Thu, 17 August 2000 09:33 Go to previous messageGo to next message
JOHN
Messages: 182
Registered: April 1998
Senior Member
You might try total number of characters for a fully populated row * the estimated number of rows. This will give you an estimate of the space required for the table.

As for indexes you might try max(length(index key)) * number of estimated rows.

Get with your DBA for any intial extents and next extent sizing and pctincrease requirements at your site.

Hope this helps.
Re: Oracle - Table Indexes - Storage Clause [message #375339 is a reply to message #375335] Thu, 17 August 2000 09:33 Go to previous message
JOHN
Messages: 182
Registered: April 1998
Senior Member
You might try total number of characters for a fully populated row * the estimated number of rows. This will give you an estimate of the space required for the table.

As for indexes you might try max(length(index key)) * number of estimated rows.

Get with your DBA for any intial extents and next extent sizing and pctincrease requirements at your site.

Hope this helps.
Previous Topic: Forms 4.5(32 bit) and Forms 5.0
Next Topic: MyOwnMenu&Smartbar
Goto Forum:
  


Current Time: Fri Mar 29 10:43:00 CDT 2024