OraFAQ Forum: SQL & PL/SQL » if Fkey not indexed ?

Home » SQL & PL/SQL » SQL & PL/SQL » if Fkey not indexed ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

if Fkey not indexed ? [message #23362]

Wed, 04 December 2002 04:40

Ramki
Messages: 26
Registered: September 2002

Junior Member

Hi all,

What will be the problem if Fkey is not indexed ?
will it lock child table, pls explain me why this is
happening.
-Thanks

Report message to a moderator

Re: if Fkey not indexed ? [message #23363 is a reply to message #23362]

Wed, 04 December 2002 05:23

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Hello, Please elobarate u r questions..
FK Not indexed ? ? ? Foreign key in u r current table is certainly a primary key in the remote database which has got an implicit index created on it..
Please let me know, where is the lock ?

sai

Report message to a moderator

Re: if Fkey not indexed ? [message #23365 is a reply to message #23362]

Wed, 04 December 2002 05:32

Ramki
Messages: 26
Registered: September 2002

Junior Member

Hi Sai,

FKey coloumn in child table is not indexed
is need to indexed ?
if FKey is not indexed then what will be the problem.

Report message to a moderator

Re: if Fkey not indexed ? [message #23370 is a reply to message #23362]

Wed, 04 December 2002 08:37

sridhar
Messages: 119
Registered: December 2001

Senior Member

>> if FKey is not indexed then what will be the problem.

You want to INDEX this one.
Problem is performance if you do not INDEX the Fkey.

Thx,
Sri

Report message to a moderator

Re: if Fkey not indexed ? [message #23376 is a reply to message #23362]

Wed, 04 December 2002 11:18

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:292016138754

Report message to a moderator

Previous Topic:	Is bind var required in side procedure ?
Next Topic:	Sheena asks how i can i get a CD of oracle 9i personal edition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 20:50:48 CDT 2024