I have a Question about the Internal Infrestructure of SQL Server?
It is true that SQL Server generates intenal Index when you creates a relation between 2 tables Child and Parent, its creates internal index by the fields related into the child table?
If this is not true, it is a good practice to create the index into the child table by every relation with a parent table.
I you have any documentation that can explainme better this, I will pareciate a lot.