Re: group by clause filling up temp space

From: ewong <ewong_at_mail.com>
Date: 30 Aug 2005 12:35:35 -0700
Message-ID: <1125430535.649775.211260@g14g2000cwa.googlegroups.com>

Here is the explain plan. I've tried 0=1 it doesn't help. And yeah this is the only query that fills up temp. Thanks.

Execution Plan

---

   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=3162293791 Card=1847
          2014 Bytes=664992504)

   1    0   SORT (GROUP BY) (Cost=3162293791 Card=18472014 Bytes=66499
          2504)

   2    1     HASH JOIN (Cost=2480 Card=193301902913 Bytes=69588685048
          68)

   3    2       TABLE ACCESS (FULL) OF 'TABLEA' (Cost=727 Card=2
          48875 Bytes=7964000)

   4    2       TABLE ACCESS (FULL) OF 'TABLEB' (Cost=644
           Card=77

9648 Bytes=3118592) Received on Tue Aug 30 2005 - 14:35:35 CDT