Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to calculate parameters for indexes?

How to calculate parameters for indexes?

From: <skadhane_at_my-deja.com>
Date: Fri, 01 Sep 2000 15:46:54 GMT
Message-ID: <8ooj17$ptm$1@nnrp1.deja.com> 






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.
Received on Fri Sep 01 2000 - 10:46:54 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US