| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: why so much slower
more info. It seemed just when I went from two to three tables in a join
there was a very substantial increase in elapsed time. I did join with one
large table and small codetable alone and performed like a champ. Hmmmm.
Any ideas?
-----Original Message-----
Sent: Wednesday, June 05, 2002 3:03 PM
To: 'ORACLE-L_at_fatcity.com'
Set sort_area_size to very large as 20Gb (obscene) amount of space
available.
Doing 2 large table outer joins returns results in .341 seconds - both
partitioned on same criteria
added one small codetable equijoin with one of the larger tables. There is
a foreign key to codetable and index that is unique.
Used hash join hint
Used nested loop hint
Basically saw two large joins sort merged hash join then nested join to smaller table - much much smaller codetable.
NO matter what it seems query is much much slower - Any ideas?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Paula_Stankus_at_doh.state.fl.us
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jun 05 2002 - 15:18:45 CDT
 |
 |