DBA question - UPDATE STATISTICS

[DirtyDog]

I'm not really a SQL server expert TBH, more of an oracle guy, but I would guess the use of a temp table simplifies the job of figuring out the join order or saves repeated executions of a subquery. IIRC you have to explicitly write your SQL to use them though don't you?

Oracle and Microsoft have VERY different interpretations of the term "temporary table"

[Spacecadet]

I'm off work today, feel free to pm me the SQL query if you like.
Chances are there will be some basic simplification steps which can speed up query execution no end.

[doodab]

Oracle and Microsoft have VERY different interpretations of the term "temporary table"

Yes i've used both. I'm just not an expert in SQL server to the same degree. I can set up backups, stats gathering and other basic dba tasks but I don't have the same level of dba experience & perf tuning expertise that I have with oracle, though to be fair thats a bit out of date now.

[oscarose]

I'm off work today, feel free to pm me the SQL query if you like.
Chances are there will be some basic simplification steps which can speed up query execution no end.

Many thanks Spacecadet - I've an interview to attend this afternoon but cheers for the kind offer.