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

AnySQL (d.c.b.a) wrote:
> The "INDEX" hint let Oracle automatically choose index, however if
> Oracle can introduce a new hint "INDEX_COL", it will really helpful.
>
> Because we may use different index name for the same table in different
> environment (PROD vs QA).
>
> And to use column on specific column is easy for developer to
> understand.
>
>
>
> Welcome, AnySQL
> =======================
> http://www.anysql.net/en/

Why do you even want to use different index names? What pressing business need is resolved using this requirement? Do you really think it makes sense to use different names?

-- 
Sybrand Bakker
Senior Oracle DBA