Should we have stats gathered on permanent tables that are used as TEMP?
We have seen that deleting stats and locking stats so they can not be gathered can significantly speed things up. Right now, I am looking at an explain plan with a merge join cartesian. As soon as a I delete stats on the two "temp" tables the plan becomes reasonable. The vendors are completely useless in advising us on this.