Does anyone have any input on these 2 questons?

Does the foreign key in a table need to be indexed when that field is
already indexed as a primary key?

Also, if you have a linking table with 2 foreign keys should those 2 keys be
combined to form a primary key for the linking table?

Thanks,
Sebastian


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to