In the following chapters, we’re going to look at some different database objects and identify some common anti-patterns with each. We discussed many anti-patterns that apply to code such as stored procedures, functions, views, or even ad hoc SQL statements. However, each object type can have it’s own pitfalls.
In this chapter, we’re going to take a closer look at tables. If every piece of code touching a certain table is slow, the table definition should be examined. What exactly are we looking for in that definition? The information in Chapter 2 didn’t really cover tables, except ...
