Index creation
From: Flávio Maciel <flaviorm_at_portoweb.com.br>
Date: 8 Aug 2002 16:25:41 -0700
Message-ID: <73d921e1.0208081525.1bf53b1e_at_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:
Date: 8 Aug 2002 16:25:41 -0700
Message-ID: <73d921e1.0208081525.1bf53b1e_at_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 Fri Aug 09 2002 - 01:25:41 CEST