Indexing Myths

I just found this article about indexing myths by Kurt Survance and I thought it is really useful to share it Myth 1: The Primary Key index must be clustered and unique. Truth: The index supporting the Primary Key must be unique, but not necessarily clustered. Explanation: There are often much better places for the clustered indexes than on the … Continue reading Indexing Myths