Re: Help rewriting query

From: News <Contact_404_at_hotmail.com>
Date: 15 Nov 2005 06:35:25 -0800
Message-ID: <1132065325.007202.9760@g49g2000cwa.googlegroups.com>

My question was not clear. The question is how to make such MV fast refreshable. The problem is with multiple instances of the same table in a query and doesn't depends on version, indexes, plan etc.

sybrandb_at_yahoo.com a écrit :

> No version.
> No information about optimizer being used and statistics being present
> and current.
> No information about indexes.
> No EXPLAIN PLAN.
> Are you serious about expecting a response?
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Tue Nov 15 2005 - 08:35:25 CST