Chapter 7: Common Sense Indexing

---

Overview

We have seen in the previous chapter how important it is to match various SQL code clauses with indexes properly. This chapter will examine the internal structure of various different types of indexes. Different types of indexes apply in different circumstances and for different tasks. Where different index structures are applicable to different tasks, indexes will often perform very poorly when used inappropriately. Thus the title of this chapter being "Common Sense Indexing" implies utilizing the appropriate index type under the correct circumstances.

Let's start with looking at what should be indexed and how.

---