I figured it out.
I have another problem. I create my materialized view. I now want to write a query
that joins it to a transactional table. I want to use query rewrite. Problem is the
join is not on the primary key of either table.
Is it possible to enable query rewrite without that? I have
public synonym?
ryan_oracle
I figured it out. I need some help with query re-write. Im not sure its possible.
My materialized view joins 3 tables on the primary key/foreign key. I have a query
that would join that materialized view to a third transactional table, but that join
is not on any primary key or foreign key.
I
ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: please help with materialized view question
I figured it out.
I have another problem. I create my materialized view. I now want to write a query that joins it to a transactional table. I want to use query rewrite. Problem is the join
, then the
materialized view needs to be reloaded. This could take a little while.
From: [EMAIL PROTECTED]
Date: 2003/12/26 Fri PM 02:09:27 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: please help with materialized view question
Warning: I have not actually used query
Normally you can get extra tables involved
with an MV by creating a Dimension that
describes all the relationships between the
tables in the MV and the tables outside the
MV - but the only times I've done this, the
extra tables have always been at the parent
end of a parent/child link to a table