Re: Oracle Performance

From: Bart the bear <bartthebear_at_gmail.com>
Date: 14 Mar 2007 11:34:49 -0700
Message-ID: <1173897289.892347.149050@d57g2000hsg.googlegroups.com>

On Mar 12, 9:30 am, "pbrajesh" <rajesh.tamil.in..._at_gmail.com> wrote:
> Hi,
>
> We have an datawarehouse database Oracle 9i.
> A table has 145 fields and 70 million records for a month.
> We want to perform an group by 5 of fields in the table .
> How to do that will minimum time ?. I wrote an oracle procedure but it
> is very slow.
>
> Thanks
> R

Truncating the table will speed things up significantly. Received on Wed Mar 14 2007 - 13:34:49 CDT