Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle should have a new hint "INDEX_COL(tname,colname)".

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

From: AnySQL (d.c.b.a) <anysql_at_gmail.com>
Date: 6 Mar 2006 06:19:22 -0800
Message-ID: <1141654762.255727.268040@e56g2000cwe.googlegroups.com> 





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/
Received on Mon Mar 06 2006 - 08:19:22 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US