I have now killed the SELECT query, which was still churning away after more than an hour.

Many thanks everyone for helping to nail this one. I can now make my case to the vendor in really distinct and specific terms.

You guys rock.

MarkD