Indexes on table used to implement many to many relationship

From: Rick <Rick.UK_at_nospam.btinternet.com>
Date: Thu, 19 Nov 1998 16:08:47 -0800
Message-ID: <3654B30F.E1C@nospam.btinternet.com>

Hi all

If I have three tables, one of which is used to implement a many to many relationship between the other two, is it better to index both key columns on the middle table in one index or separate ones?

eg Tab A

cols keyA

blahA

Tab B

cols keyb

blahB

Tab AB

cols keya

keyb

should one index on keya and keyb be produced on tab AB, or one each on keya and keyb separately?

Thanks in advance for any help

Rick Received on Thu Nov 19 1998 - 18:08:47 CST