Hi Tony > 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? 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. HTH Chris -- http://www.freelists.org/webpage/oracle-l