Re: orace sql query

From: EdStevens <quetico_man_at_yahoo.com>
Date: Mon, 25 Jun 2007 18:29:00 -0700
Message-ID: <1182821340.585456.157330@c77g2000hse.googlegroups.com>

On Jun 22, 12:37 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Jun 22, 12:28 pm, EdStevens <quetico_..._at_yahoo.com> wrote:
>
> > On Jun 22, 12:15 pm, sathishkes..._at_gmail.com wrote:
>
> > > i want to create table with primary key but with out index
>
> > How do you think Oracle enforces the PK?
>
> > go to tahiti.oracle.com and search the concepts manual for 'primary
> > key'.
>
> http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a769...
>
> Please read this; you're sorely in need of this information.
>
> David Fitzjarrell

David,

I hope you meant that for the OP, and just clicked on the wrong link for your reply. I'm sure there's lots of stuff I'm sorely in need of information on, but the reference cited (which is exactly the one I double checked before responding to the OP) clearly says " PRIMARY KEY Constraints and Indexes Oracle enforces all PRIMARY KEY constraints using indexes."

But then I'm also painfully aware that there really are "unknown unknowns." Received on Mon Jun 25 2007 - 20:29:00 CDT