Category Archives: indexing

Optimizing Database Performance

Posted on August 29, 2023 by craig@craigsmullins.com

Last week I was proud to publish my latest database book, this time on the important topic of achieving and maintaining efficient performance for your databases and the applications that access them. Appropriately enough, this book is titled Optimizing Database … Continue reading →

Posted in analytics, availability, data availability, DBA, indexing, operational, optimization, performance | Tagged , , , | Leave a comment

The 7 Types of Database Design Reviews

Posted on December 12, 2013 by craig@craigsmullins.com

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 | 19 Comments

Top Ten Steps to Building the Right Indexes

Posted on August 30, 2013 by craig@craigsmullins.com

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