Total index maintenance

There is no magic in indexes. Instead, it is all about timing and balance.

A few quick word on index structures – nothing deep here, I am sure if you are reading this, you already know enough about index structures:

indexes are organized in B-trees, i.e. leaf structures comprised of hierarchical pages, pointing to each other
there are

Continue reading […] Total index maintenance […]

 

Pave the shortcuts!

Here is a real life example of a great concept: great unpaved shortcuts in their glory.

Pave the shortcuts!

The reality is that if there is a well-stomped shortcut somewhere, then it should definitely be paved. After all, it is well-stomped because many have taken it. And if many have taken a shortcut, this means

Continue reading […] Pave the shortcuts! […]