> -----Original Message----- > From: Constantin Stefanov [mailto:[EMAIL PROTECTED] > Sent: 11 February 2004 09:52 > To: Andreas Pflug > Cc: Dave Page; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Indexes generated for primary > key are not show > > Andreas Pflug wrote: > > > Well it's not really hard, just some things to think of. And the > > longer I think about it, and looking at your example, I'd > say people > > analyzing a query should know a little what pgsql is doing, > e.g. that > > unique and primary constraints include an index. Thus I tend to say > > we'll stay with what we got now. > I can't completely agree with you. I use only PostgreSQL, but > I used to help my colleague working with Oracle (he was a > novice), and I looked at his result of EXPLAIN (it was > different from what PostgreSQL gives, but quite clear). I am > not sure that in every database engine PRIMARY KEY constraint > is implemented using index.
Well I can't say with abolute certainty that *all* do, but I would be surprised if they didn't - after all, a pkey is only a unique index which is flagged as primary and not null. Oracle certainly does implement pkeys as indexes. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
