Re: create a view with parallel hint

Hi Oxnard, Pratap and all,

Thanks for your suggestions.....

I need to combine the full and parallel hint for this query otherwise the CBO chooses an index and that plan takes too long to run (68 mins vs 5 for the parallel FTS).

I can't change the tables parallelism,.. too much impact on the rest of the system. Too risky.

Re "sometimes hints work in a view sometimes not".. I can't get the hints in the view to work at all and global hints are not an option as they'd require a hint in the top level query.

A stored outline is an option. I may have to go down that route.

Thanks for the feedback
Cheers
Tony

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