Re: Sizing Tables
Date: Sat, 21 Jul 2001 21:56:48 GMT
Message-ID: <tj4g3t8002eu55_at_xo.supernews.co.uk>
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