Re: Sizing Tables

Recommended book:-

Oracle Performance Tuning, 2nd Edition
Published by O'Reilly

By Mark Gurry & Peter Corrigan
2nd Edition, 1-56592-237-9, Order Number: 2379

Is definitely a good book for sizing and tuning in general. It is worth every penny. When I worked for Oracle consultants would swear by this book.

See the following link for an overview:-

http://www.oreilly.com/catalog/oracle2/

Nick

[Quoted] "Larawole" <larawole_at_aol.com> wrote in message news:20010621083231.03598.00000310_at_ng-cf1.aol.com...
> 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 Sat Jul 21 2001 - 23:56:48 CEST