RE: create a view with parallel hint

From: Christian Antognini <>
Date: Fri, 28 Mar 2008 08:13:16 +0100
Message-ID: <>

Hi Tony

> create or replace view EVENT_T_parallel_historic as
> select * /*+ full(eph) parallel(eph,8) */
> from
> then reference EVENT_T_parallel_historic in the main query.
> But,... when I run the query, the hints are ignored.
> Can hints be used within views in this manner,
> and/or am I doing something wrong here?

Hints in view can be used (even if it is not generally really advised to do so). Anyway, to solve a problem like your, it is ok.

If you really created the view with the SQL statement you posted, the problem is simply that you have placed the "*" before the hint, and not after.

If you used another SQL statement, than, please, post it... There is for sure something wrong. Either a hint is not correctly used or you didn't specify enough hints.


Received on Fri Mar 28 2008 - 02:13:16 CDT

Original text of this message