Paul McNett wrote:
>>> IF FILE("POSTCODE.DBF")
>>> WAIT WINDOW NOWAIT 'Reindexing postal codes'
>>> Select 0
>>> Use postcode Exclusive
>>> IF FILE('POSTCODE.CDX')
>>> Delete Tag All Of postcode
>>> endif
>>> Index On Upper(town) Tag postc1
>>> Index On Upper(street) +Upper(town) Tag postc2 For !Empty(street)
>>> Index On Upper(town) +ruraldel Tag postc3 For !Empty(ruraldel)
>>> Index On Upper(town) +Str(pobox1)+Str(pobox2) Tag postc4 For
>>> !Empty(boxdisp)
>>> Index On Code Tag postc5
>>> Use
>>> ENDIF
>> Are there any stats that give you info on the USAGE of your indexes?
>> I would consider them reset at a reindex process.
>
> I disagree. I think that excessive trips to Burger King and McDonalds
> contribute
> greatly to global warming.
>
> ;)
>
> Paul
Hi Paul,
Good that you are paying attention to the cause de jure. However it
depends greatly on time and temperature. When it is unseasonably cold
then it is "just weather", BK or McD notwithstanding.
--
Regards,
Pete
http://pete-theisen.com/
http://elect-pete-theisen.com/
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://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.
