It is helpful to index the keys that are used in a foreign key relationship. This way the the query engine has to check for the existence of the key, it does not have to do a table scan.
Foreign keys by them selves have no part in indexing, ie you must place indexes on them. looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X
looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
Marked as answer byKJian_Tuesday, January 12, 2010 10:38 AM