Picture of Markus Winand

The art of indexing is to reach best performance with as few indexes as possible.

Not Many Indexes, but the Right Ones

About 50% of all SQL performance issues are related to the poor use of indexes. That’s why Markus Winand is very concerned about proper indexing. In addition to his website, his book and his trainings on this topic, Markus Winand also offers a full index redesign for your database.

An index redesign not only improves the performance of single SQL statements, it aims for the smallest number of indexes that serve all SQL statements. The result is better performance for the entire application.

The Procedure

Index redesign projects are highly customized for you individual needs—please ask for a specific project plan. Nevertheless, there are some common project phases that might help you when it comes to understanding how an index redesign works.

  • Data Collection

    For an index redesign, Markus Winand has to know all of the SQL statements executed by your database. Most databases offer a tool to trace all activity. Furthermore, the database schema—including current indexes—and statistical information about the data distribution is needed. If security allows for it, you can also provide a full (anominized) database export.

    Data collection is carried out by your staff. Of course you get the exact requirements and some recommendations for the collection in advance.

  • Analysis and Optimization

    Markus Winand performs the analysis, optimization and validation using his own IT resources. In case you did not provide a full database dump, the validation is done on a generated dummy database based on the statistical information you provided.

    This phase is conducted in three steps: (1) fully automatic analysis and pre-optimization; (2) manual optimization; (3) validation and prognosis.

    The result is a written report with tuning opportunities outlined. The tuning opportunities incorporate your requirements, such as the software and hardware architecture and your specific type of project planning. Every tuning oppotunity comes with a benefit prediction.

  • Validation and Deployment

    Your staff revalidates the tuning opportunities and tests them—often during a regular release cycle. In this phase, the activity on the database can be traced again so that Markus Winand can validate the correct implementation and also check whether the predicted benefits occurs.

    After your approval, your staff does the production rollout.

Get in Touch

Alternatively to the form below you can also send an e-mail to office@winand.at to get in touch.

Privacy: The provided data is solely used to make you an offer and subsequent invoicing.

About Markus Winand

Markus Winand is an independent author, trainer and consultant on all things SQL. His book “SQL Performance Explained” has just been translated into a fifth language. It can be purchased as a print edition, and it’s also available to read for free on his use-the-index-luke.com website. Markus is currently working on his second book centered on the idea that things have changed a lot since SQL-92. It is likewise available free of charge online (modern-sql.com). Markus Winand is regularly speaking at international conferences and user groups.

Connect with Markus Winand

Markus Winand on LinkedInMarkus Winand on XINGMarkus Winand on Twitter