REPOST: Re: Interesting warehouse design challenge (long)

1 mat. view for each clause is great if they are stagnant, but we unfortunately have the requirement that they can change during the day.

It's 700,000 records. How can I know how big to increase the size of the SGA to fit the whole thing?

Thanks for your help.

-M

"Keith Boulton" <kboulton_at_ntlworld.com> wrote in message news:VGv48.26592$Ph2.4700925_at_news2-win.server.ntlworld.com...
> I don't know too much about it, but could you not build a materialised
view
> for each where clause and refresh it each time the main data is refreshed.
I
> did something similar recently and it improved performance enormously,
> althouh it eventually turned out to be unnecessary ( improving run-time
from
> .3 seconds to 0.02 doesn't seem worthwhile).
>
> How big is the table? You may find that you can increase the size of the
SGA
> to hold the entire table - in one case, I got a 10-fold performance
> improvement from this.
>

• WAS CANCELLED BY =======: From: "markoos" <no_at_spam.com> Control: cancel <2Vx48.52181$d16.8906500_at_typhoon.nyc.rr.com> Subject: cmsg cancel <2Vx48.52181$d16.8906500_at_typhoon.nyc.rr.com> Date: Mon, 28 Jan 2002 01:17:04 GMT Message-ID: <cancel.2Vx48.52181$d16.8906500_at_typhoon.nyc.rr.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.fh-hannover.de!fu-berlin.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40720628

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Sat Jan 26 2002 - 07:10:22 CST