On 2018-01-24 13:48, Kurt at VR-FX wrote:
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-
But if I did that, think of the discussion and thread that would be
missed here. LOL
This question relates to VFP CDX files but is something in theory too
for other systems (although I realize they may do things differently).
I just dropped a boatload of nonsense indexes from a client's legacy app
database and believe that it (theoretically) should improve network
traffic by lessening these unneeded updates.
_______________________________________________
Post Messages to: [email protected]
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/[email protected]
** 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.
