Sandy (7/30/2008)
(Still i wants to know should i create index or not on the foreign key column.....he he he..lolz....:))
As I said several times in this thread, probably but test to be sure. There are no hard and fast absolutes when it comes to indexing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass