Hi all,
Running VFP 5.0a. I have a local view which I'm trying to optimize. I use sys(3054,1) to get information about the Rushmore optimization level.

This is reported full optimization using all my indices:
SELECT * FROM MyTable where
but when I type
CREATE SQL VIEW 'Whatever' AS SELECT * FROM MyTable
the optimization is only partial using my index on deleted.

Doesn't SYS(3054) give complete information on local views? Should I test the optimization level by excluding 'CREATE SQL VIEW AS' and later on consider the local view fully optimized (when SYS(3054,1) reports so) or is my local view not fully optimized?

Confused as usual....
/Pierre Unge, Sweden