index Archive

Test Your Index Design Skills

You know how to design indexes, but you’re not sure how good your skills really are. In this quiz-packed session you’ll get a chance to test your SQL Server index design skills!

Getting the Best Out of Your MySQL Indexes

MySQL indexes are often used to make performance better. However, they can make performance suffer if you are not using them properly. MySQL Guru Sheeri Cabral explains the pitfalls to avoid with indexes and how to utilize

Lightning Fast SQL with Proper Indexing

Proper indexing is a very time and cost-effective way to improve performance. Yet it is often done in a very sloppy way. This talk explains the organizational misconceptions that lead to sloppy indexing and gives advice how

Best Practices for MySQL Indexing

Proper indexing is a key ingredient of database performance and MySQL is no exception. In this session we will talk about how MySQL uses indexes for query execution, how to come up with an optimal index strategy,

Tools and Techniques for MySQL Index Design

MySQL users commonly ask: What indexes do I need? Why aren’t my indexes helping me? Don’t indexes cause overhead? This webinar will provide practical, step by step methods for finding the queries you need to optimize and