Re: Optimization Level

From: Cindy Winegarden (
Date: 03/24/04

Date: Wed, 24 Mar 2004 10:56:53 -0500

In news: OCVYaQbEEHA.2548@TK2MSFTNGP12.phx.gbl,
Michael Shaw <> wrote:
> I have tried the same query with set deleted off and the query reports
> 'Full' as expected.
> I am not sure why deleted has to be 'off' when there are no deleted
> records in the table.

Hi Michael,

Test your optimization with Deleted off and if you get "Full" you'll know
you've got everything set right. Then change Deleted to whatever you usually
run with.

Cindy Winegarden  MCSD, Microsoft Visual FoxPro MVP