… to understand how indexing works and so index all columns used in the queries…. separately. So you end up with table which has say 20 indexes… spotted with a glance view. If you have queries with multiple column restrictions in WHERE clause you most likely will need to have multiple column indexes…
Percona's MySQL & InnoDB performance and scalability blog
Percona Webinars
Careers at Percona
- Sales and Marketing Operations Engineer
- Trainer (Worldwide)
- Software Engineer
- Regional Support Sales Representative
- MySQL Consultant (American timezones)
MySQL Training from Percona
- Orlando, USA on Monday, 11 June 2012
- Raleigh, USA on Monday, 18 June 2012
- Boston, USA on Monday, 09 July 2012
- Chicago, USA on Monday, 09 July 2012
- Los Angeles, USA on Monday, 23 July 2012
Copyright © Percona Inc. • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.