Re: Confused with Primary Key and Index

Answers embedded.

<u132781982_at_spawnkill.ip-mobilphone.net> wrote in message news:l.985277197.1716430664_at_[198.138.198.252]...
> Sorry if my question sounds stupid,
> when you create a primary key, does
> oracle always create an index associate
> with that primary key?

YES! Will this index
> have the same name as your primary key?

OF COURSE
>
> If the table is partitioned, can we also
> partitoned the index as well? How can you
> know this index is from primary key or is
> a pure index?
>

BY joining dba_indexes to dba_constraints as I already showed you!

Sigh

Regards,

Sybrand Bakker, Oracle DBA

and please stop crossposting, you'r not getting a bigger audience as most people responding monitor all three newsgroups.

> Thanks for your help
>
>
>
>
> --
> Sent by dbadba62 from hotmail within area com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Thu Mar 22 2001 - 18:46:42 CET