Re: Performance problem

From: Brad Odland <bodland_at_cpm.com>
Date: 1997/10/04
Message-ID: <3435E27F.F309EDCE@cpm.com>#1/1

One it sounds like you really have a datamodel problem...WHy would you want to join a table twice with such a large table....?? I would assume you have..
1. Made sure the indexes for the tables in question are being used during your operation.
2. Parallel Query options are set for each table envolved in the query.

Some thoughts:
YOu should built a secondary structure that contains the information that is accessed frequently...

Hope it helps....

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
Received on Sat Oct 04 1997 - 00:00:00 CDT