Hi skasarla,

I tried the composite index on tblline and the same, as I've just posted above the plan is the same as it was before.

All the fields I join on and use are indexed.

If you have any more ideas they will be much appreciated.

Paul