RE: foreign key constraint and the index_name in user_constraint table
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <nn20002@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 1 Oct 2004 09:38:13 +0200
maybe I don't understand your question, but ...
the index has nothing to do with the constraint --
that's why you don't see the index name associated with the constraint in
the data dictionary.
indexes are only relevant to guard primary key and unique constraints ...
now, whether or not your index is *used* in some cases is a different story.
you will need tu use diagnostic tools to check for index usage.
Kind regards,
Lex.
-------------------------------
visit http://www.naturaljoin.nl
-------------------------------
skype me <callto://lexdehaan>
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of nn20002@xxxxxxxxxxxx
Sent: Friday, October 01, 2004 00:51
To: oracle-l@xxxxxxxxxxxxx
Subject: foreign key constraint and the index_name in user_constraint
table
Hi,
Could you please help me in this issue.
I have a foreign key on a child table referencing the primary key of the
parent table. I have created the index on the foreign key on the child
table. Now, how do I know that the foreign key constraint is using the index
or not.
I tried to see the index name from user_constarints table, but it always
shows empty. When index_name is empty, what does it mean, even though I have
it.
Thanks
nagu
__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
Netscape. Just the Net You Need.
New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
