Sizing Tables

[Quoted] 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.

Also if I have a unique index on column1, how do i size the index.

Many Thanks
Mikey Received on Thu Jun 21 2001 - 14:32:31 CEST