Oracle should have a new hint "INDEX_COL(tname,colname)".
AnySQL (d.c.b.a)
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/
Chuck
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"
sybr...@yahoo.com
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
DA Morgan
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
damo...@x.washington.edu
(replace x with u to respond)
Sybrand Bakker
wrote:
>If the indexes have different names the DBA should be asked to
>resign.
Aren't the customary exit procedures in the US (unlike many civilized
coutnies) quite different?
--
Sybrand Bakker, Senior Oracle DBA
Joel Garry
>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
DA Morgan
Absolutely ... an unfortunatly. Honor and personal integrity are
quaint attributes of earlier generations.
oracle_doc
Actually, it's already there!
In 10g, there is an improved version of INDEX hint
INDEX(tab1 tab1(ind_col1, ind_col2))
By specifying the index columns rather than the index name, Oracle can
pick up any index with these columns as the leading portion of the
index key. When you think about it it's a much better hint, approaching
the problem from the right direction - the search criteria from the
logical perspective rather than a particular physical object.
yon...@yahoo.com
Hi, oracle_doc,
You're one of the few gentlemen that have good memory! About this day
last year, Jonathan Lewis told us this (still) undocumented feature
http://groups.google.com/group/comp.databases.oracle.server/browse_frm/thread/de056ba01e68c621
See message 9 and later.
If you see it documented anywhere, let us know.
Regards,
Yong Huang
AnySQL (d.c.b.a)
Welcome, AnySQL
==============================
http://www.anysql.net/en/