RE: foreign key constraint and the index_name in user_constraint table

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 1 Oct 2004 09:38:13 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNAEHLCJAA.lex.de.haan@naturaljoin.nl>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of nn20002_at_netscape.net Sent: Friday, October 01, 2004 00:51
To: oracle-l_at_freelists.org
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
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 01 2004 - 02:33:57 CDT