Re: Can you hint a table from a 'Merged' view...?

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Mon, 21 Aug 2006 17:01:33 GMT
Message-ID: <44e9e6ae.882031@news.hetnet.nl>

On 21 Aug 2006 01:55:14 -0700, mccmx_at_hotmail.com wrote:

>Oracle 10.2.0.2 SE and Windows.
>
>I have a view which has been merged into an outer query. I want to
>apply a USE_HASH hint to one of the tables the view. Is it possible to
>do this....?
>
>If so, where does the hint go (in the view definition or in the calling
>query). Do I need to use the table alias from the view definition or
>the full table name or the view alias...?
>
>Matt
>

Look up 'Specifying global table hints' in the Performance Tuning Guide.

Jaap. Received on Mon Aug 21 2006 - 12:01:33 CDT