Re: How to calculate parameters for indexes?

skadhane_at_my-deja.com wrote:
>
> What is the way to calculate parameters( initial and next) while
> creating indexes?
>
> Say i want to create a index on 4 columns of a table which has 50,000
> rows which has
> monthly growth of 10,000 rows.The columns are
> varchar2(20),number(10),varchar2(10),number.
>
> What factors will you consider so that it index wont use more no of
> extents.
> And what are the other things that should consider while creating
> indexes.
>
> Thanks
>
> SK
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

One of the appendices in the Oracle (Concepts I think) manual has a detailed calculation...But in the preferred environment nowadays of uniform extents for objects in tablespaces, you can make an "guestimate" and go with that...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse