Re: Problems with materialized views in Oracle8i

This is the one that I'm having trouble with.

The joinback works if there is only ONE table to join back to, and the dimension is defined to be within a single table.

However, if the join back is to two tables, and the dimension is defined across these two tables (in fact my dimension is defined across 3 tables) then the rewrite does not occur - even when I include the hint.

If I use an inline view to encapsulate the materialized view with the first joinback, and then join the second joinback to it, then everything works okay - but I don't (can't) do that in 'real life'.

If your examples include one of these could you let me see it please - I can't spot any errors in what I've done.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Mark Townsend wrote in message <37732DFA.24459914_at_us.oracle.com>...
>4) Summary Joinback - the query requires some data not stored in the
>summary, but can use the summary information to facilitate a join back
>into the base tables - basically, the summary drives the join. This last
>case is a special case, and may also require the definition of dimension
>hierarchies.
Received on Fri Jun 25 1999 - 03:35:52 CDT