How to use and edit Outlines
108885Jan 29 2009 — edited Jan 30 2009Can somebody provide me some information on how to edit and create Outlines in 11g? I have a case where we are using a third party tool whose generated SQL we can't control and it is generating a query that is incredibly slow due to the optimizer's choice of an index to use. Since we can't add a hint to the query, my understanding is that I should use stored Outlines. I can see how to create one but I am unclear as to how to add a "NO_INDEX" hint / how to tell it not to use and index. Can anybody provide me help on how to do this?
Thanks,
Greg