Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: User experiences on DW query runtimes

Re: User experiences on DW query runtimes

From: news <kennedy-family_at_home.com>
Date: Thu, 29 Nov 2001 17:26:09 GMT
Message-ID: <RcuN7.1268$726.357650@news1.sttln1.wa.home.com>


I would think an SLA would be difficult since a lot of the limitations would be IO limitations.
Jim
"James Williams" <willjamu_at_mindspring.com> wrote in message news:3c062632.85126816_at_nntp.mindspring.com...
> I have create a new datawarehouse. We have a couple of queries that
> access 150 million row fact tables against diminsion tables. I don't
> think one hour run time is unreasonable.
>
>
> Anybody established any types of SLA's one data warehousing.
>
> If the user needs quicker response we can always do MVIEW's.
Received on Thu Nov 29 2001 - 11:26:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US