The index for DELETED() is only justifiable if deleted records are more than 20% of the total records of the DBF.
Not always the "full optimize" is the best option, and sometimes it takes more time than without this index. Best regards.- 2014-07-16 22:56 GMT+02:00 Ted Roche <tedro...@gmail.com>: > Sytze: > > I've been surprised to find everyone works with a "large amount of data" > but for some of us, that's thirty thousand records and for others it is > thirty million. > > > INDEX ON pcode TAG pcode > INDEX ON pcode2 TAG pcode2 > INDEX ON pcode3 TAG pcode3 > INDEX ON DELETED() TAG DELETED > > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/CAGQ_JukkVCS-knD+hD35XMo0GvMP2sB28UQv8aEA_hL-dE=k...@mail.gmail.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.
