Primary Key equivalent to non-clustered index?
Hi,
i just got acquainted with the idea of indexes. Based on my understanding:
1. For every primary key ( single field/ multiple fields), an index based on the key will be created automatically. Bingo or wrong?
2.Each table can only have 1 clustered index, multiple non-clustered indexs. Bingo or wrong?
So is the index created based on the primary key a clustered or non-clustered index? I would think its the non-clustered index. Bingo or wrong?