Index Myths and Best Practices
In the past few chapters, we’ve defined indexes and looked at how they are structured. In the upcoming chapters, we’ll be looking at strategies to build indexes and ensure that they behave as expected. In this chapter we’ll be dispelling some common myths and building the foundation for how to create indexes.
- Databases don’t need indexes.
- Primary keys are always ...