Elyse,

It sounds like you need indexes on the key fields you're using to join tables a and b. Make sure the index expression is exactly the same as the expression you're using to join the tables. For example. If your join looks like this:

tablea.aKey = tableb.aKey

Make sure that both table a and table b have an index on aKey.

>I'm trying hard to optimize (speed up) my local view. I'm trying to use the SYS(3054) function, but either the documentation is poor or I'm missing something. So far, it tells me "Rushmore optimization: full" for each of my tables. Then it tells me "Joining table a and table b using temp index." This seems to take a long time. Is there a way to speed up the join?
>
>Thanks,
>Elyse