It would only be missed if you didn't report your results and included a

spreadsheet and a graph! :)

Paul

-----Original Message-----

From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of

mbsoftwaresolutions@mbsoftwaresolutions.com

Sent: Wednesday, January 24, 2018 12:58 PM

To: profoxtech@leafe.com

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

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.

[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/023701d39548$1698e860$43cab920$@tpcqpc.com

** 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.