>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
You can count on if the SQL that creates the view is optimized, then the view will be optimized. Also, look at SYS(3054, 11), which adds join optimization to the results.
Erik Moore
Clientelligence