It isn't true, and hasn't been as far back as Oracle 6. (I can't speak for 5
but I know there are people here who could). SAo no don't seperate out
according to column width but according to the logical model for your app.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Chad Stansbury" <stansburyc_at_earthlink.net> wrote in message
news:evuk8.22251$Vx1.1914401_at_newsread1.prod.itd.earthlink.net...
> 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 Sun Mar 17 2002 - 11:38:40 CST
