Hints Enhancement

[Covina]

I would like to see list of Hints in LOV popup
when I type SELECT /*+

User should be able to pick one of the possible hints from .

Can this be done?

 

[Marco Kalter]

It is definitely doable, and I have added this to the list of enhancement requests.

 

[Milan]

I think that you should provide templates library for hints. That would be quick and easy solution

 

[Stew Stryker]

Milan,

I thought of this just the other day. If you've built one, care to share with the rest of us?

It could be simple (w/o prompts) or complex, whatever you've got.

Thanks,

 

[CTzen]

Please don't forget about second way to add hints

--+

 

[Milan]

I don't have the library. Does anybody else have it?

 

[Joachim Rupik]

Here you are...

Access Path hints in templates
Optimization Goal Hints in templates

It was done many years ago , but you can simply improve it.

Marco, if you want, you can obviously include my templates in official distribution.

Joachim Rupik

 

[Marco Kalter]

Thanks, we'll check it out.