Re: primary keys and indexes
Date: 27 Oct 1994 15:34:50 GMT
Message-ID: <38ohaq$nl9_at_ixnews1.ix.netcom.com>
In <38ipst$5ht_at_raffles.technet.sg> shchua_at_solomon.technet.sg (Chua Song Heng) writes:
>
>are primary keys in version 7 also indexes?
>i want to know whether i need to create indexes if i am accessing the
>table through the primary key.
>if primary key already exists, does creating index on the same fields
>speed up access ?
>
>A prompt reply is appreciated. Thanks.
>
>
The uniqueness of primary keys is enforced by unique indexes.
When you create a primary key constraint, an index is automatically creates, assuming the constraint is enabled. (If not enabled, then the index won't be created).
All of this is covered in the manuals.
-JJ
Jeffrey Jacobs & Associates
Oracle CASE Consulting and Training
951-2 Old Country Road, Suite 119
Belmont, CA 94002
Voice: 415-571-7092
FAX: 800-665-1379
CompuServe: 76702,456
Internet: jjacobs_at_well.com
Internet: jmjacobs_at_ix.netcom.com
Received on Thu Oct 27 1994 - 16:34:50 CET