Help! weird Common Table Expressions behavior with SYSTEM TEMP TABLESPACE
in [DB2]
|
Prev: Doubts about CHECK CONSTRAINT
Next: Help! weird Common Table Expressions behavior with SYSTEM TEMP TABLESPACE
From: Oleg Kozlovski on 13 Nov 2009 06:09 Hi all! I have a quite complicated query, which uses 4 or 5 common table expressions and produces about 155000 rows. But recently it started to consume the disc space at alarming rate. Investigations shows that it is due to the SYSTEM TEMPORARY TABLESPACE with the page size 8K. Dropping this TS solves the problem, query works fine (having only one TS with 4K, created by default). But I need the bigger TS for other queries. What could cause this? It worked fine before, both TS exist for a quite long time... |