Leyne, Sean wrote:

> Next, why did you choose to use a FULL join? Wouldn't a LEFT JOIN been
> more appropriate?

I want the same records to appear, but with the SM_SELECTED.ID field either NULL
when there is no record, or to have a value if the record has been selected.
Wouldn't a left join exclude the records where the join fails?

> Finally, unless you have an index on Status, the system will be
> performing joins for all 400,000 sawmember rows.

There is an index on status. This is needed for its ability to exclude the
archived records (STATUS = 4).

Thanks for your thoughts, but still no explanation about why it should take 20
times longer to do a query which has a lookup into a small table on it primary key.

Regards,

Mark Patterson