Re: Performance problem

nmk_1970_at_hotmail.com wrote:
>
> 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 Usenet

Have you tried using Explain Plan to see if you are using your indexes properly? Sounds like a cartesional join. You can also try using a temporary table.

-- 
Sheilah Scheurich
DBA

My opinions are my own and not that of my 
employer.

To respond via email, remove underscores.