Tag: dense index
-
What is an index – a theory (part 1/4 – dense and sparse indexes)
Since I had written a few posts about indexes before, I thought it would be good to shed some light on theory behind indexes in SQL Server. It would be divided into four parts: Dense and sparse indexes (this post). B-trees – searching for a value and operation efficiency. B-trees – inserting an item, operation…