Re: Primary Key and Indexes, are they necessary?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 14 Jun 2006 21:05:08 +0200
Message-ID: <e6pmft$45u$1@news3.zwoll1.ov.home.nl>

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!

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Wed Jun 14 2006 - 14:05:08 CDT