The art of indexing is to reach best performance with as few indexes as possible.
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.
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 opportunity 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.
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.
As the SQL Renaissance Ambassador, it’s my mission to make developers aware of the evolution of SQL in the 21st century. My book “SQL Performance Explained” has been published in five languages and can be read online free of charge at use-the-index-luke.com. My next book is currently in the works and can already be read online as it’s being written (modern-sql.com). I am available as a trainer, speaker and consultant for all companies and developers interested in SQL. You’ll find more info at winand.at.
