8 Table Design That Works for You
Obsession with order and detail can be a good thing. When you’re running out the door, it’s reassuring to see your keys hanging on the hook where you always leave them. The same holds true for database design. When you need to excavate a nugget of information from dozens of tables and millions of rows, you’ll appreciate a dose of that same detail obsession. With data organized into a finely tuned, smartly named set of tables, the analysis experience becomes much more manageable.
In this chapter, I’ll build on Chapter 7 by introducing best practices for organizing and speeding up SQL databases, whether they’re ...
Get Practical SQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
