Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server

On 3 Dec 1997 04:58:19 GMT, satriguy@aol.com (SaTriGuy) wrote: :>} :>} What an overhead, delete followed by insert. An in situ :>} update is far more efficient. Use it wherever possible. :> :>An update IS a delete followed by an insert. : :Sorry - not true. The update is on the same physical page as the original row. : If the row is a displaced row because is is using varchars, the update will :attempt to place the displaced row back on it's home page. The only :delete/inserts that occur are to index items that might have been altered by :the update. He should have said sometimes .... gburnore@netcom dot com or gburnore@netcom databasix com --------------------------------------------------------------------------- How you look depends on where you go. --------------------------------------------------------------------------- Gary L. Burnore | '۳'''''''ۺ''''''''''۳ | '۳'''''''ۺ''''''''''۳ DOH! | '۳'''''''ۺ''''''''''۳ | '۳ 3 4 1 4 2 '' 6 9 0 6 9 '۳ spamgard(tm): zamboni | Official Proof of Purchase =========================================================================== PGPprint: C63B CF4E 1B71 4D7E C6F8 AF4E 338D 5CB4 KeyID: 0x0F7EDBD9 (RSA) finger gburnore@netcom.com for public key ---------------------------------------------------------------------------