Hi Todd,

VFP uses two optimizations: Filter Criteria and Join Criteria . There're no Filter Criteria (WHERE clause) in both tables that why no optimization for cr and fd tables reported. However there's optimization on Join Criteria which is reported. Anyway, as long as query is fast enough, ther's nothing to worry about. :)

BTW, you can enable Auto-quote from the Tools menu so you don't have to copy previous message manualy into your reply. You can also use < pre > < /pre > tags (w/o spaces) to preserve code formatting.

>I think I got it.
>
>Both SQL display the same SYS(3054) message:
>Rushmore optimization level for table cr: none
>Rushmore optimization level for table ff: none
>Joining table ff and table cr using index tag Linkfield
>
>But with about 1.2 million records in crzplots and about 69k in imsfilter, the selection time for the "JOIN" solution is down to .4 seconds.
>
>Should I be concerned that the optimization levels are none? Or can it be even better?