Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Table Sizing
The simple solution is to multiply the row length by the number of rows.
The same can be figured for the index, multiply the column(s) length by the
number of rows.
Jen
Larawole wrote:
> I have read numerous books but I still have not found a book that describes
> how
> to accurately size a table
>
> If I have a table
> create table tableA
> (column1 varchar2(20),
> column2 char(5),
> column3 number(5,2),
> column4 number(4));
>
> And I expect to have around 1000 rows in tableA. How do I calculate the
> storage parameters(estimate) without having to load sample data
>
> Also if I have a unique index on column1, how do i size the index.
>
> Many Thanks
> Mikey
>
Received on Thu Jun 21 2001 - 08:06:30 CDT