Click to See Complete Forum and Search --> : Hint


bang_dba
11-11-2005, 04:22 PM
I have a query q1 which is selecting from a view v1. There are some Hints in the view v1, due to which the query q1 is performing badly. I want query q1 to ignore the Hints present in the view V1. Is it possible to do it ?

At this point in time, i am not allowed to recreate the view v1 due to some process problems. I want to handle it in the application query.

davey23uk
11-12-2005, 01:46 PM
you cant get the optimizer to ignore hints

slimdave
11-12-2005, 02:34 PM
What hints are they?