Showing entries 1 to 2
Displaying posts with tag: lookup (reset)
Oct
18
2017
Webinar Thursday, October 19, 2017: What You Need to Get the Most Out of Indexes – Part 2
Posted by MySQL Performance Blog on Wed 18 Oct 2017 18:46 UTC
Tags:

Join Percona’s Senior Architect, Matthew Boehm, as he presents What You Need to Get the Most Out of Indexes – Part 2 webinar on Thursday, October 19, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7).

Register Now

Proper indexing is key to database performance. Finely tune your query writing and database performance with tips from the experts. MySQL offers a few different types of indexes and uses them in a variety of ways.

In this session you’ll learn:

  • How to use composite indexes
  • Other index usages besides lookup
  • How to find …
[Read more]
Jul
14
2011
Understanding B+tree Indexes and how they Impact Performance
Posted by Ovais Tariq on Thu 14 Jul 2011 10:03 UTC
Tags:

Indexes are a very important part of databases and are used frequently to speed up access to particular data item or items. So before working with indexes, it is important to understand how indexes work behind the scene and what is the data structure that is used to store these indexes, because unless you understand the inner working of an index, you will never be able to fully harness its power.

Showing entries 1 to 2