DA,
I replied to the last response to my question. I also asked the
quetion because I was hoping to find out what others might do in this
same situation. Let me rephrase my question since you seem to be to
dense to understand my question. I have a very compex SQL query that
involves decodes and functions run on various tables to form a table
that makes it easier to report off of for our report designers. it
also uses outer joins to join two tables. I am not the one who
designed the SQL query that creates the current view just the one who
has to fix it. 10.1.0.3 would be the correct version. What I am
trying to achieve is a materialzed view that would refresh on commit.
It seems since i use such a compex query fast refresh is out of the
question. Full refresh is where I am confused. What if this query
takes 90 minutes to run? DOes this mena the MV would take 90 minutes
to refresh?
DA Morgan wrote:
> cptkirkh wrote:
> > MY best would be most efficnet with the most current data. We are
> > running 10g
> > DA Morgan wrote:
> >> cptkirkh wrote:
> >>> What is the best way to refresh a MV that is based upon a complex SQL
> >>> query that joins three tables? I would prefer fast refresh on commit.
> >>> Thanks for your help.
> >> Define "best" and include your version.
> >> --
> >> Daniel A. Morgan
> >> University of Washington
> >> damorgan_at_x.washington.edu
> >> (replace x with u to respond)
> >> Puget Sound Oracle Users Group
> >> www.psoug.org
>
> 1. Please don't top post. This isn't email. Scroll to the bottom to reply.
> 2. Your definition of best has no meaning. If there was a single "best"
> solution Oracle wouldn't have bothered to implement Materialized Views,
> or any other technology, with multiple choices. Is there someone senior
> in your organization that can help you understand the issues?
>
> With respect to version, 10g means what: 10.1.0.3 or 10.2.0.2 or other?
> You need to be specific.
>
> Start here:
> http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6002.htm#SQLRF01302
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Mon Jan 15 2007 - 09:26:01 CST
