On Friday, September 13, 2002, at 10:03 AM, Chuck Urwiler wrote:

> Just ideas from the top of my head. I've never seen a reason to turn

> it off in my experience.

The reason given for providing SET OPTIMIZE OFF is for dynamically

changing data, where your index cache might be out of date. Turning off

Rushmore forces VFP to look at the table itself, not a cached copy of

an index.

___/

/

__/

/

____/

Ed Leafe

http://leafe.com/

http://foxcentral.net