Re: Help!

From: Matthias Gresz <GreMa_at_t-online.de>
Date: Thu, 17 Dec 1998 08:00:48 +0100
Message-ID: <3678AC20.A46B53E0@Privat.Post.DE>

HLim168 schrieb:
>
> Can I build index on primary key?

Oracle automatically builds an index every time you set up a primary key constraint. It uses the default storage parameter that are defined for the user's default tablespace for this index. This often doesn't reach your needs. In order to change storage parameters use the 'USING INDEX' clause to specify other storage parameters.

HTH
Matthias
--
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Thu Dec 17 1998 - 01:00:48 CST