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
Continue reading […] Total index maintenance […]