Re: Foreign Key Columns And Indices

Stephan Szabo wrote:
>
> On Mon, 5 Feb 2001, Christopher Kings-Lynne wrote:
>
> > Just a quick question, when a column of a table is defined to be a foreign
> > key, is it implicitly indexed, or does one still need to explicitly CREATE
> > INDEX?
>
> The foreign key columns are not currently implicitly indexed but you may
> wish to index them if you're using a referential action other than no
> action or restrict.

You'd probably want to index them either way, because even
"NO ACTION" and "RESTRICT" mean that a scan for existing
references is done on updates/deletes to the PK.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com