On Mon, Jul 04, 2005 at 20:29:50 -0400,
  David Gagnon <[EMAIL PROTECTED]> wrote:
> Thanks .. I miss that FK don't create indexed ...  since Primary key 
> implicitly does ...
> I'm a bit surprised of that behavior thought, since it means that if we 
> delete a row from table A all tables (B,C,D) with FK pointing to this 
> table (A) must be scanned. 

But in some applications you don't ever do that, so you don't save
anything by having the index for deletes but have to pay the cost to
update it when modifying the referencing table.

If you think an index will help in your case, just create one.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to