Mike,

If I was to look at this from a totally Logical stand point - I would

think the Indexes are ONLY update if you update a field in a record

where that field is contained in one or more of the Indices.

However, Why not do a simple test - and generate your Own answer!??

Take a chunk of the data from your table in question - or even take a

copy of the Whole thing, along with the Indices, drop into another

folder. Then - simply do some updates based upon your criteria below -

and then you can confirm Exactly what happens!

Right???

:-)

-K-

On 1/24/2018 1: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]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/9ab07317-d4fe-6c03-cba0-3190f0d58033@optonline.net

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.