Re: Fixed- vs. Variable-width tables

I can't think of a single part of what you wrote that is valid in any version of Oracle that has been sold in the last decade.

And by all means do not used fixed-width columns unless there is a specific requirement. The cost of trimming fields is very real.

Daniel Morgan

Chad Stansbury wrote:

> Hello -
>
> A few years back I remember that it was very important to make sure that you
> defined tables w/ just fixed width columns (placing variable-width columns
> in a separate table), making it much faster to update the one table since it
> could be done in-place, and that fixed-width tables are generally more
> efficient. Now, the question is, how true is that statement nowadays, have
> new algorithms made that performance tweak unnecessary?
>
> Assuming that I will query on the fixed-width table the most, should I go to
> the trouble of separating out the two tables?
>
> Thanks in Advance, Chad
Received on Fri Mar 15 2002 - 17:15:28 CST