Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Performance problem
Hi netters,
I have a table which consists of 24 M Rows with the data size of 8 GB which is spread across 8*1 GB each. I have a need to join these table with a small table of 112 rows . The small table has to be joined twice with the big table to achieve the task. when I do this it is really sucks. Also I have to do group by with 10 columns on this query. I have temp segment size of 1.2 GB . Currently I am running oracle 7.3.2.3 on sun solaris 2.5. Even after 12 hours I am not able to get the output.
Any suggestions are welcome.
Thanks in advance.
/muralikrishna
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Thu Oct 02 1997 - 00:00:00 CDT