RE: Unnesting Subqueries in an Outline

Luke,

Please, put an or AUTOTRACE traceonly EXPLAIN ) plan, with and without
NO_UNNEST, just to check.

regards,

alvaro.

>We have logged a call with Oracle who can re-create the problem but we 
>have had no response other than WIP.  The problem does not exist in
10g.

>Has anybody got any ideas how we can get this query to perform without 
>changing the SQL?

Thanks
Luke


The contents of this message and any attachments are confidential and
are
intended for the use of the persons to whom it is addressed.
If you are not the intended recipient, you should not copy, forward, use
or
alter the message in any way, nor disclose its contents to any other
person.
Please notify the sender immediately and delete the e-mail from your
system.
The sender is not responsible for any alterations that may have occurred
without
authorisation. Any files attached to this email will have been checked
by us
with virus detection software before transmission.
You should carry out your own virus checks before opening any
attachments, as we
do not accept any liability for loss or damage which may be caused by
viruses.

For information regarding company registration please visit the contact
page at www.hansard.com
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Other related posts: