Category Archives: Database Internals
The Guts of Indexing – Part 1
In my last post I used the analogy of a Library to describe indexes. However, I used very abstract ideas and did not speak to how an index in the database is structure, how it works, etc… In this post I … Continue reading
Posted in Database Internals, Databases
Tagged clustered, database, database internals, datebase indexing, indexes, indexing, library, sql server
Leave a comment
Indexes By Analogy
Recently I ran across a blog which tried to use the analogy of a library to describe the difference between clustered and non-clustered indexes in SQL Server. I found the post useful as a very general idea of indexes though I thought … Continue reading
Posted in Database Internals, Databases
Tagged clustered, database, database internals, indexes, library, sql server
1 Comment
Chuck Normal Form 