You could rename the table and then create a view of the table with the
hint. I wouldn't do that, but you could.
Jim
"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:02:43 CST
