Re: Oracle should have a new hint "INDEX_COL(tname,colname)".

AnySQL wrote:

>The "INDEX" hint let Oracle automatically choose index, however if
>Oracle can introduce a new hint "INDEX_COL", it will really helpful.

You got it backwards. Hinting HINDERS the ability to let Oracle automatically choose the index. If your developers are having to put in a lot of hints, there is perhaps something wrong with their perception of CBO.

Is it really so hard for your developers to understand they should be explicitly naming everything consistently?

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20060304/news_1b4google.html