I am curious if there are any rules of thumb for when to index a
foreign key column? I was under the impression that it was always a
good idea to do this based on the fact that you typically join
through a foreign key but after reading the docs I'm not so sure it's
necessary or provides any
Josh Trutwin [EMAIL PROTECTED] writes:
I am curious if there are any rules of thumb for when to index a
foreign key column?
(You realize of course that there's already an index on the referenced
column, else you wouldn't have been allowed to reference it.)
You need an index on the referencing
On Tue, 28 Aug 2007 13:19:32 -0400
Tom Lane [EMAIL PROTECTED] wrote:
Josh Trutwin [EMAIL PROTECTED] writes:
I am curious if there are any rules of thumb for when to index a
foreign key column?
(You realize of course that there's already an index on the
referenced column, else you