Automatic index generation & little tunning

Article View: comp.databases.oracle.server

Article #76

Back to comp.databases.oracle.server Previous Next

#76

From: Jordi Bellver
Date: Sun, 26 Apr 1998 00:00

22 lines
1384 bytes

    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

Technical Details

Message-ID: <35429D1D.782E39E9@tau.uab.es>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f99a8,7001ecb7d2eba85f,start
X-Google-Attributes: gidf99a8,public
X-Google-Thread: fa4f9,7001ecb7d2eba85f,start
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: 103117,7001ecb7d2eba85f,start
X-Google-Attributes: gid103117,public
From: Jordi Bellver <bellver@tau.uab.es>
Subject: Automatic index generation & little tunning
Date: 1998/04/26
Message-ID: <35429D1D.782E39E9@tau.uab.es>
X-Deja-AN: 349144177
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Reply-To: bellver@spam.tau.uab.es
Content-Type: text/plain; charset=us-ascii
Organization: TAU
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc,cern.oracle.cde