Re: Primary Key and Indexes, are they necessary?

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 14 Jun 2006 12:26:46 -0700
Message-ID: <1150313210.891730@bubbleator.drizzle.com>

Frank van Bortel wrote:
> Brian Peasland schreef:
>

>>
>>>   up.  Especially, if the DB is not fragmented.  
>>
>> Fragmentation has nothing to do with adverse performance. If your 
>> vendor is saying that fragmentation is killing your performance, then 
>> they are living in the dark ages.
>>

>
> I was about to respond "change vendor; he thinks you're a fool, and
> still uses pre-V7 adagios", but I'm glad I didn't ;)
>
> And all about the referential integrity, I can only agree with.
> Really, ever since V5, primary keys have been in place, and never
> has anyone thought about getting rid of these for performance
> reasons.
> Your vendor does not do referential constraints, does he?
> Because if he does, his implementation is slower than Oracle,
> I can guarantee you that!

Slower and guaranteed not to work when anyone is loading or altering data by any means other than the vendor's own toolset.

But then who ever connected to Oracle with SQL*Plus or SQL*Loader? Why hardly anyone.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed Jun 14 2006 - 14:26:46 CDT