Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: User experiences on DW query runtimes
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
![]() |
![]() |