Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: disabling use of VW_SNO_1

Re: disabling use of VW_SNO_1

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 25 Aug 2004 23:04:26 -0700
Message-ID: <1093500318.521524@yasure>


MAK wrote:

> Hello!
>
> Please review the following SQL and Explain plan. How can I disable
> use of VW_NSO_1? Oracle implicitly create this view to unnest the
> subquery.
>

You can not except in that you provide the optimizer some rationale for not building it. And since you have Siebel you have my condolences.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Aug 26 2004 - 01:04:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US