RE: create a view with parallel hint

The form  

select

--+ full(eph) parallel(eph,8)

<column_list>

from <whatever>  

should survive the passage and be treated as comments through all ANSI compliant interfaces. Well - if they are in fact ANSI compliant rather than just being called ANSI compliant. I didn't read the rest of the thread in detail, so I'm not commenting on getting the parallel stuff to work per se. I think Greg Rahn demonstrated that, anyway. And he or someone mentioned you having the column list before the hint. This is more about getting it through ODBC and other interfaces that strip block comments.  

I'm not entirely sure why we all don't routinely write hints in this form, other than habit and the documentation always being in the form /* ..... */. Of course the - form is limited to a single line, but that should suffice for hints. Mike Brown first brought this to my attention, and I'm not sure whether someone clued him in to it or he tried it on a whim after noticing some interfaces stripped /* ... */ before they get to the Oracle parser. I'm not sure why ANSI compliant interfaces routinely strip block comments but allow single line comments through, but so far it seems to work.  

regards, mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Friday, March 28, 2008 2:06 AM
To: tony.adolph.dba_at_gmail.com
Cc: oracle-l
Subject: Re: create a view with parallel hint  

Tony

I believe that you'll need to be using a native and not an odbc connection to get the hints to be recognised. (Crystal used to allow for native/oledb and odbc connections and only the native connection was any good really) note I haven't looked at it for 2 years.

<snip>

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.

<snip>

--
http://www.freelists.org/webpage/oracle-l




application/ms-tnef attachment: winmail.dat