SQL Server – Does an Index B-Tree structure always have a root page?
Hi Friends, This is a common question I face in many of my classes and consulting assignments? The answer is NO. Indexes are B-Tree structures (balanced tree) where navigation/searching happens from …
SQL Server – Does an Index B-Tree structure always have a root page? Read More