Category Archives: indexing

The 7 Types of Database Design Reviews

A little more than two years ago I wrote about The Importance of Database Design Reviews here on this blog. The general idea of that post is that reviewing the scope and content of a database implementation before it moves … Continue reading

Posted in database design, indexing, normalization, performance, SQL | 16 Comments

Top Ten Steps to Building the Right Indexes

One of the more vexing problems with relational database development is designing appropriate indexes. Perhaps the most important thing you can do to assure optimal application performance when accessing data in a relational/SQL database is to create correct indexes for … Continue reading

Posted in data, database design, indexing, SQL | Tagged | 2 Comments