Newsletter Subscription | Glossary | Contact Us
Home > All Categories > MySQL > Tuning > Multiple column index vs multiple indexes
Question Title Multiple column index vs multiple indexes
Authored by: Thomas Darwin
Viewed: 98 times so far

After my previous post there were questions raised about Index Merge on Multiple Indexes vs Two Column Index efficiency. I mentioned in most cases when query can use both of the ways using multiple column index would be faster but I also went ahead to do some benchmarks today.

I'm using couple of simple tables:

Read more ...

Author : mysqlperformanceblog.com
Click Here to View all the questions in Tuning category.
File Attachments File Attachments
There are no attachment file(s) related to this question.
User Comments User Comments
There are no user comments for this question. Be the first to post a comment. Click Here
Post Comment Add a Comment
Email Address:
Comment/Message
Verify Code

Post Comment How helpful was this article to you?
Related Questions Related Article
  1. 15 tips on optimising MySQL databases and MySQL queries
  2. Real World Web: Performance & Scalability, MySQL Edition
  3. A Few Common Performance Mistakes
  4. MySQL Conference Keynote 2008 - Scalability Panel
Article Information Additional Information
Article Number: 384
Created: 2008-08-26 5:40 PM
Rating No Rating
 
Article Options Article Options
Print Question Print this Question/Article
Email Question Email this Question/Article to Friend
Export to MS Word Export to MS Word
Bookmark Article
del.icio.us Bookmark del.icio.us Bookmark
Digg It Digg It
Furl It Furl It
Subscribe to Article Subscribe to Article
 
Language Translation Language Translation
 
Search Knowledge Base Search Knowledge Base

 
  Copyright © Mentat Technologies