Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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/
>
Naming the indexes the same across environments would be a lot easier than getting Oracle to change their RDBMS code. Perhaps you should just synchronize your environments. That's what I would do.
-- To reply by email remove "_nospam"Received on Mon Mar 06 2006 - 09:03:55 CST
![]() |
![]() |