Home » Other » General » Re: Index on Foreign key
Re: Index on Foreign key [message #102396] Mon, 20 May 2002 11:53 Go to next message
llow
Messages: 1
Registered: May 2002
Junior Member
Hi, we all know that having indexes on foreign keys reduces locking considerably, however, if a foriegn key happens to be a primary key or the first column of a primary key, do I still need to create an additional index on it? I think the answer is no, but just want to be sure.

Thanks!

Report message to a moderator

Re: Index on Foreign key [message #102399 is a reply to message #102396] Mon, 20 May 2002 22:30 Go to previous message
Ranganath P
Messages: 5
Registered: May 2002
Junior Member
Index on Foreign key

Report message to a moderator

Previous Topic: Re: How get the next row from the array (see example)
Next Topic: Re: Oracle 8i New Features for Administrators
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 03:23:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.