Hi,
I would say you have it right. The filter applies to the WHERE clause and the join is for the JOIN ON part.
You may want to look at http://fox.wikis.com/wc.dll?Wiki~SelectSQL~VFP for a discussion of VFP and SQL Select. http://fox.wikis.com/wc.dll?Wiki~NonDiscriminatingIndex~VFP is also pretty interesting. There may be a complete discussion of VFP optimization in a book somewhere (I read an excellent one on SQL Server 6.5) but I don't know of it.



>Hi all,
>I need some clarification on the SYS(3054,12) command and the difference between the JOIN and FILTER output sections.
>
>Background: I'm optimizing a few SQL-Selects that use the JOIN syntax. Most do not have a WHERE clause.
>
>The help is kind of vague on how to interpret the two sections of the report. I'm assuming that for my purposes the JOIN section is what I should be concerned with. The FILTER section will be useful only when I have a WHERE clause?
>
>Here is a sample of the output I get:
>
>Rushmore optimization level for table a: none
>Rushmore optimization level for table b: none
>Rushmore optimization level for table c: none
>Rushmore optimization level for table d: none
>Rushmore optimization level for table e: none
>Joining table b and table a using index tag _1
>Joining intermediate result and table c using index tag _1
>Joining intermediate result and table d using index tag _1
>Joining intermediate result and table e using index tag _1
>
>
>The FILTER section shows rushmore optimization only for tables with a tag on DELETED() (with SET DELETED ON).
>
>TIA!