Re: sql question

From: news.tele.dk <bajon_at_nospam@worldonline.dk>
Date: Wed, 25 Oct 2000 10:34:48 +0200
Message-ID: <8t65v8$hd4$1@news.inet.tele.dk>

SQLs on the columns in question (the WHERE clause) linking the master and child table perform better - in most cases.
Deletes from the master table will place row locks in stead of table locks on the child table.

Hth,
Ivan Bajon, ocp

<volk333_at_my-deja.com> wrote in message news:8t5quf$i1n$1_at_nnrp1.deja.com...
> what happens if an index is created on a foreign key column?
> i met this question in some braindump for OCP.
> someone can help me answer this?
> thank you
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Oct 25 2000 - 03:34:48 CDT