Vin..


A link table will frequently be used in joins and queries. The query optimizer strongly favors a clustered index. Of any kind of table, I could see where a link table might benefit more since a clustered index would ensure records that are grouped together would be physically ordered together.

I would encourage you to check out the responses from Travis, Val, and Rod as well.