Automatic index generation & little tunning

    Hi !!

    Can someone explain under What circunstances are index automatically generated ?
I know that, when I create a table with PK, automatically is generated an index for this table,
but... has the same result a Fk ? or a NOT NULL constraint ?

    And related with index and tunning, I think that default Storage parameters and
increase parameters are in general good, not allways.

    For a example, if in table A I've lots of inserts and updates, what are the best
parameters ? (PCTFREE, MINEXTENTS, PCTINCREASE...)

    And if in table B are only 1 insert and lots of selects ? (by a PK with its own index)

Thank's in advance !

bye Received on Sun Apr 26 1998 - 00:00:00 CDT