Re: Query tuning experts: Any hope for tuning query with 5+ joins and a sort?

I think that's probably a fairly precise summary of what often happens -

I remember feeling as if I was the only person in the world who was running OPS with parallel query and partition views in 7.2.3 - and WHY (for example) did the PQ person think that a query would be limited to only 255 bind variables when the PV person changed date predicates to bind variables against every individual table in the view !

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Paul Brewer wrote in message
<3dd18d38_1_at_mk-nntp-1.news.uk.worldonline.com>...


>Oracle are good at bringing out a load of new features with each

release.


>The problem appears to be that the separate teams responsible for

each


>feature carry out regression testing of their particular feature

against


>some 'common' codebase.

>Then, at the eleventh hour, everything is built for the production

release.


>All (most of?) the individual new features do exactly what they say

on the


>tin, but combine them at your peril...

>