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 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