>Thanks for the tip. This is with VFP data. Here's what I get when I do some SYS(3054) and SET ALTERNATE on a large multitable join. The local view weektime_complete is "none", why is that?
>
>

>  Using index tag Deleted to rushmore optimize table weektime
>  Rushmore optimization level for table weektime: full
>  Rushmore optimization level for table reportnames: none
>  Using index tag Deleted to rushmore optimize table projtask
>  Rushmore optimization level for table projtask: full
>  Using index tag Deleted to rushmore optimize table projname
>  Rushmore optimization level for table projname: full
>  Rushmore optimization level for table weektime_complete: none
>

You give no indication of your table structures, indices, etc. Superficially it looks like there's no applicable index tag on table "reportnames". As for "weektime_complete", if that's a view (i.e. you're view definition includes another view), if it doesn't have an available/useful index, it's going to come up "none" as well. You can manually index a view (you may have to temporarily switch buffer modes while you do so). OTOH, if you *are* making a view of a view, you may need to re-think your whole approach.