RE: create a view with parallel hint

From: Baumgartel, Paul <>
Date: Thu, 27 Mar 2008 13:05:07 -0400
Message-ID: <>


You need to use global hints. Check the Performance Tuning manual for details; 10g version is at htm#PFGRF50104.


Paul Baumgartel
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
Phone 212.538.1143

-----Original Message-----

[] On Behalf Of Tony Adolph Sent: Wednesday, March 26, 2008 9:41 PM
To: oracle-l
Subject: create a view with parallel hint

Hi folks,

After some tuning I went back to the developer and recommended a new super version, slightly changed and including a full and a parallel hint. The new query runs in 5 mins vs 68mins for the old, so a result.

The problem I have is that query is generated by Crystal Reports. Currently we don't know how we can include the hints in the report (the developer is looking into this as I type).

To work around this problem I created a view that includes the hints, and then changed the main query to use the query instead of the original table.

Something like this....

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?

Any pointers appreciated.

PS: Oracle

Please access the attached hyperlink for an important electronic communications disclaimer:

-- Received on Thu Mar 27 2008 - 12:05:07 CDT

Original text of this message