Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: disabling use of VW_SNO_1
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