Re: Plea for Query Tuning Help

Norman,
if you use the "view" several times in the query, CBO can decide to materialize it, without the hint.

rgds

On 9/13/06, Norman Dunbar <norman.dunbar_at_environment-agency.gov.uk> wrote:
>
>
> Morning all,
>
> >> It is more than cosmetic as it can be referenced multiple times and
> the
> >> query is only run once and materialized, then processed as a table
> in the
> >> main query
>
> Correct me if I'm wrong, but I'm sure it is only materiali[sz]ed if you
> use the materialize hint ? Jonathan has a post somewhere on this list on
> this very subject (I think !).
>
>
> Cheers,
> Norman.
>
> Norman Dunbar.
> Contract Oracle DBA.
> Rivers House, Leeds.
>
> Internal : 7 28 2051
> External : 0113 231 2051
>
>
> Information in this message may be confidential and may be legally
> privileged. If you have received this message by mistake, please notify the
> sender immediately, delete it and do not copy it to anyone else.
>
> We have checked this email and its attachments for viruses. But you should
> still check any attachment before opening it.
>
> We may have to make this message and any reply to it public if asked to
> under the Freedom of Information Act, Data Protection Act or for
> litigation. Email messages and attachments sent to or from any Environment
> Agency address may also be accessed by someone other than the sender or
> recipient, for business purposes.
>
> If we have sent you information and you wish to use it please read our
> terms and conditions which you can get by calling us on 08708 506 506. Find
> out more about the Environment Agency at www.environment-agency.gov.uk
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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