primary key and foreign key
primary key and foreign key
От:
Jessica Richard <rjessil@yahoo.com>
Дата:
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?
Thanks.
Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.
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?
Thanks.
Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.
Re: primary key and foreign key
От:
Richard Broersma Jr <rabroersma@yahoo.com>
Дата:
--- Jessica Richard 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 index is needed on the F-key column, it has to be created, right? Correct. Regards, Richard Broersma Jr.