Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> hash joins and pga/temp space?

hash joins and pga/temp space?

From: <ryan_gaffuri_at_comcast.net>
Date: Tue, 14 Nov 2006 15:19:07 +0000
Message-Id: <111420061519.17501.4559DE6B0002213E0000445D2200763692079D9A00000E09A1020E979D@comcast.net>


If I do a query that is doing a hash join. Is the amount of pga/temp space required based entirely on the table that is hashed (smaller) table. Or will more temp space be required for a larger table?

Also, after a table is hashed and the join takes place, is the result set temporarily stored in pga/temp space before being return (or pushed to another operations?).

Is there anyway to calculate how much pga/temp space will be required for a hash join if you know how much data will be queried from each table? This could be useful for predictive modelling. For example we have a query that does a hash join in. We know our data sets will increase to X. How much more temp space can we estimate we need for this query?

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 14 2006 - 09:19:07 CST

Original text of this message

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