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

Oh, forgot to mention -
What is the query? Does the hint work in testing and not just in theory. Can you describe the table the query runs against? I take it stats are up to date? How is it laid out? Number of rows? Partitioned? Indexes? What sort of data? Explain plan and stats for query with and without HINT? The more info you give, the more people reading the post can help.

Regards,
Kyle

"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 - 21:03:56 CST