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

How flexible is the third party? They may supply a point release especially for you with hints included. Hey, we can all wish.....

What hints are you thinking of as there are some init.ora parameters that can influence the optimizer into going down road A or road B. Say for example if your multiblock read count is very high, this can make it favourable to do FTScans. Saying that, fiddling with that, could end up being swings and roundabouts.

Would really need to know what HINT you wanted to add.

Regards,
Kyle
www.gadgets.co.nz

"Forte Agent" <1443131_at_usenetplanet.com> wrote in message news:sm6aaus83hvb5253q6ptv8voggsm49vb37_at_4ax.com...
>
>
> 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.
>
>
>
>
>
>
Received on Fri Mar 29 2002 - 20:53:56 CST