the same size is if all you columns in the table are fixed size. Notably
VARCHAR is not, and a great percentage of tables have at least one VARCHAR
field. As soon as you mix in any column of varying length, you've got
variable length rows, so you can't always reclaim the space.
Cheers,
barneyb
> -----Original Message-----
> From: Claude Schneegans [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 01, 2004 2:52 PM
> To: CF-Talk
> Subject: Re: Which to use as primary key?
>
> >>Because if they don't overwrite on updates, the position of the
> record changes. That requires a change in the index too.
>
> I see.
> But are there such databases systems?
> I mean, since all records are the same size, what's the big
> idea not overwriting it on an update?
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
