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
Write the SQL statement you want.
When it is doing what you want.
Prepend CREATE OR REPLACE VIEW to your SELECT statement.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Aug 21 2006 - 10:47:21 CDT
