Yes you should index all linking keys. They don't have to be primary indexes. I always set the primary index on the tables most heavily used search. Primary indexes are faster because the data is actually stored in that order in the table. -----Original Message----- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: 10 February 2001 15:41 To: CF-Talk Subject: 2 Dabase Questions 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
