Re: Oracle Performance

From: Bruintje Beer <me_at_knoware.nl>
Date: Wed, 14 Mar 2007 17:44:33 +0100
Message-ID: <45f8266f$0$744$5fc3050@dreader2.news.tiscali.nl>

"pbrajesh" <rajesh.tamil.india_at_gmail.com> schreef in bericht news:1173706257.681444.29140_at_j27g2000cwj.googlegroups.com...
> 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
>

145 columns for a table sounds like poor database design. Consider redesign, create indexes on columns you need

John Received on Wed Mar 14 2007 - 11:44:33 CDT