RE: create a view with parallel hint
Date: Thu, 27 Mar 2008 13:05:07 -0400
Message-ID: <21469B88E0EA11498818517F2103353101C66106@EPRI17P32001A.csfb.cs-group.com>
Tony,
You need to use global hints. Check the Performance Tuning manual for
details; 10g version is at
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/hintsref.
htm#PFGRF50104.
Regards,
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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
EVENT_T partition (PARTITION_HISTORIC) eph;
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.
Cheers
Tony
PS: Oracle 9.2.0.6
--
http://www.freelists.org/webpage/oracle-l
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 27 2008 - 12:05:07 CDT