Re: Problems with materialized views in Oracle8i

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 21 Jun 1999 13:47:57 +0100
Message-ID: <929969606.19344.0.nnrp-08.9e984b29@news.demon.co.uk>

Yes,

There seem to be some limitations about how many tables from the materialized query can appear in the query to be rewritten, so I have a lot more tests to do.

Examples will appear on my website in a week or so.

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

rssacks_at_ibm.net wrote in message <376e2f0f_at_news1.us.ibm.net>...
>Our initial tests have shown that the query rewrite function just works
when
>there is an exact match to the query in the materialized view. Does anyone
>have a different experience.
Received on Mon Jun 21 1999 - 07:47:57 CDT