Re: What to do? - When optimizer hints cannot be added

Never used Plan Stability. Doesn't the statement thrown at you by the 3rd party app have to match character for character to the one stored in the outline - hints and all? If it does, I can't see this working.....as the hint would have to be in the 3rd party generated statement.

Would be interested in an answer from someone who has used outlines.

Thanks,
Kyle

"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:ud6xmsf5b.fsf_at_rcn.com...
> On Fri, 29 Mar 2002, 1443131_at_usenetplanet.com wrote:
> >
> >
> > Let's say you have tables that are already designed well for optimal
> > performance (table partitions, indexes, materialized views, and so
> > on). Also, let's say there are some queries that are doing full
> > tablescans very badly and you know what hints to add to make them work
> > better. However, there are some situations where you cannot change
> > the queries: such as when the queries are coming from third-party
> > applications. What can we do in such case? Thank you in advance.
>
> I would guess that Optimizer Plan Stability would allow for this. (My
> take on this feature is that you create a plan in another instance that
> fits the plan you want and then you export that to the instance you are
> working on). I haven't used it so maybe the experts can comment?
> --
> Galen deForest Boyer
> Sweet dreams and flying machines in pieces on the ground.
Received on Fri Mar 29 2002 - 22:41:12 CST