Re: performance: index on foreign (primary) key ???

From: Mario Perreault <mperreau_at_ville.quebec.qc.ca>
Date: Sat, 18 Sep 1999 11:45:22 -0400
Message-ID: <37E3B391.71F58B7F@ville.quebec.qc.ca>

You must create an index on the column of the first table...

The primary key of the second table work only for this table!

Mario Perreault, Ville de Québec

DBA     \\\|||///
        /  ^ ^  \
        (  0 0  )

------oOOo-(_)-oOOo-----
mperreau_at_ville.quebec.qc.ca
mario.perreault_at_bigfoot.com

---

Michael Keppler a écrit :

> Hello everybody !
>
> I have a column that always references the primary key in another table
> as foreign key. Now I do a query on that column in the first table. Can
> I speed up this query by creating an index for the column in the first
> table or will the optimizer use the (primary) index of the second table
> for this ??
>
> Ciao and Good Bye, Michael.
>
> --
> Michael Keppler, MCSE, MCP+I
> IT logic GbR
> Michael.Keppler_at_gmx.de
Received on Sat Sep 18 1999 - 10:45:22 CDT