Bridget,

>Using SYS(3054,11) instead of SYS(3054,1) gives the additional information that the tables are being joined "using temp index". Does that mean I'm missing an index that would help?

Yes... Check again if you have an index on Element on both tables. Are you by any chance using different collate indexes? Check if they're MACHINE (by list structure command).

If the join is optimized, then you should notice a dramatic speed increase.

Walter,