On Mar 12, 6: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
You can also play with the definition of "minimum time." For example,
summary tables push the time to before when people are querying the
table. See http://pjsrandom.wordpress.com/2007/02/05/summary-table-design/
and posts about summary tables by oraclesponge.wordpress.com . As
Mark and Robert pointed out, you can often be quicker keeping to SQL
engine built-ins rather than PL/SQL, if you can. Posting your
procedure might allow people to critique it, if you can't use straight
SQL.
jg
--
@home.com is bogus.
http://www.autoblog.com/2007/03/12/its-done-aston-martin-sold-for-925-million/
Received on Wed Mar 14 2007 - 13:50:37 CDT
