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: Interesting warehouse design challenge (long)

Re: Interesting warehouse design challenge (long)

From: Keith Boulton <kboulton_at_ntlworld.com>
Date: Sat, 26 Jan 2002 13:27:54 -0000
Message-ID: <C6A48.28739$ka7.4741856@news6-win.server.ntlworld.com>


> 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 doesn't matter. All your queries will run against the main table. A new query may or may not be able to use a materialised view and will take a little longer. One approach is to monitor the queries being stored and create new MVs as required. After all, each one takes only a minute or two to create. Received on Sat Jan 26 2002 - 07:27:54 CST

Original text of this message

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