Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.
>
Received on Sat Jan 26 2002 - 07:10:22 CST