Index creation

From: Flávio Maciel <flaviorm_at_portoweb.com.br>
Date: 8 Aug 2002 16:25:41 -0700
Message-ID: <73d921e1.0208081525.1bf53b1e@posting.google.com>

Consider a basic many-to-many relationship where you have two foreign keys that are also the primary key of this relationship table. My question is: what's are the differences and implications of:

- building an index for the primary key and each foreign key?
- building an index just for thew primary key?
- building an index just for the foreign keys?

If I have the index for the primary key, is it needed to have indexes for each foreign key individually?

Thanks in advance

.
. Flávio Rodrigues Maciel
. Idea Tecnologia da Informação
. http://www.ideati.com.br
.
. Porto Alegre, RS - Brazil
....
Received on Thu Aug 08 2002 - 18:25:41 CDT