thanks for your reply George

select from sys.traces returns nothing - I did make sure of that earlier - i even turned of the default sql trace.

OK - i wont do anything in terms of the cost threshold.

i know there are table scans and there are lots - working on these. Stats are fresh - twice weekly - however a nightly update wouldn't hurt

I'll have a look at the cpu app and see what this turns up

thanks

john