DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Hint

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    Hint

    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.
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you cant get the optimizer to ignore hints

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    What hints are they?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width