[BUGS] Huge query stalls at PARSE/BIND stage (2)

_open_fullypaid | numeric | amt_open_live | numeric | amt_open_successful | numeric | amt_open_trace | numeric | amt_open_expired| numeric | Please help.. I'm stuck for ideas and need the new columns. Am I hitting some kind of limit that is

Re: [BUGS] Huge query stalls at PARSE/BIND stage (2)

I've been investigating this problem further. I've tried adding first just 2, then 4 more FULL JOINs to the statement. This works and the statement gets to INSERT and completes successfully. If I add 16 further FULL JOINs however, it does not. Regards, Matt P.S. Apologies for the grammar er

[BUGS] Huge query stalls at PARSE/BIND stage (1)

(Resending) Hi I have a nightly process which distills a range of statistics from a third-party database into a set of temporary tables, and then from those tables, aggregates and joins these figures into two main tables. Each temporary table contains a moderate number of rows and few columns. T