Re: Indexes on VFP tables--when do they get updated

-- Alan Bourke alanpbourke (at) fastmail (dot) fm On Wed, 24 Jan 2018, at 6:29 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote: > Question for you legends of the Fox (data): > > Say Table1 has "X" number of indexes. Program code does something like > the following: > > IF Condition1 THEN > REPLACE Field1 with SomeValue in Table1 > ENDIF > > IF Condition2 THEN > REPLACE Field48 with Datetime() in Table1 > ENDIF > > Are each of the "X" indexes updated for each replace, even if those > indexes do not include any reference to Field1 or Field48, or only > indexes that are affected by the data value change? > > I understand that ADDing and DELETEing records updated all indexes; I > would think the UPDATEs--regardless of what fields updated--would cause > index updates for every indexed field on every update as well. > > tia, > --Michael > [excessive quoting removed by server]