Re: Help rewriting query

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 15 Nov 2005 07:52:01 -0800
Message-ID: <1132070008.125010@yasure>

News wrote:

> 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

Please do not top post.

And still not version or optimizer information.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Tue Nov 15 2005 - 09:52:01 CST