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 should Oracle add a hint to cover for the horrifyingly bad discipline and practices of a development team?

If the indexes have different names the DBA should be asked to resign.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)