Re: [ADMIN] primary key and foreign key

2007-07-25 Thread Richard Broersma Jr
--- Jessica Richard <[EMAIL PROTECTED]> wrote: > Just want to be very clear that: > > 1. adding a primary key will have an implicit index automatically on the > column(s). > > 2. Adding a foreign key will NOT have an index created automatically, it only > does the > referencing work. If an in

[ADMIN] primary key and foreign key

2007-07-25 Thread Jessica Richard
Just want to be very clear that: 1. adding a primary key will have an implicit index automatically on the column(s). 2. Adding a foreign key will NOT have an index created automatically, it only does the referencing work. If an index is needed on the F-key column, it has to be created, right?