In article <evuk8.22251$Vx1.1914401_at_newsread1.prod.itd.earthlink.net>, "Chad
says...
>
>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
>
>
believe you might mean SQLServer (sybase and later MS). There an update was
almost always processed as a DELETE/INSERT causing the row to "move". In place
updates were rare.
--
Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/
Opinions are mine and do not necessarily reflect those of Oracle Corp
Received on Sun Mar 17 2002 - 11:51:08 CST
