Re: Simple update question.

In article <1993Nov22.074305.16837@twg.com> cauhape@twg.com (Jeff Cauhape x7147) writes: >Pardon me for asking a stupid question, but ... > >When a record is updated with the SE 5.0 engine, is the data >re-written to the existing record, or is a new record written >and the old one marked for deletion/re-use? > >I don't recall seeing this discussed in the manuals, and the >answer will determine the order of some weekly maintenance scripts. The way to tell this ( for SE ) is to check all the rowids in the table. Do an update, re-check all the rowids. If they are all the same, it updates inplace. That's what I think happens, just the indexes get re-written if needed. -- Robert Minter Data Systems Support Programmer, Software Development Orange, CA internet: rob@dssmktg.com Tel: 714.771.0454 bangpath: uunet.uu.net!dssmktg!rob Fax: 714.771.3028