Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: group by clause filling up temp space

Re: group by clause filling up temp space

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: 30 Aug 2005 12:25:05 -0700
Message-ID: <1125429905.414283.63220@g47g2000cwa.googlegroups.com>

Add AND 0 = 1 to the predicate...

Seriously, it is hard to say. At the very least post a full explain plan (including bytes/card column values).

Is this the only query on the system? Received on Tue Aug 30 2005 - 14:25:05 CDT

This message: [ Message body ]
Next message: ewong: "Re: group by clause filling up temp space"
Previous message: ewong: "group by clause filling up temp space"
In reply to: ewong: "group by clause filling up temp space"
Next in thread: ewong: "Re: group by clause filling up temp space"
Reply: ewong: "Re: group by clause filling up temp space"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US