Abhimanyu
Reputation: 4917
What is a MYSQL composite index?
Advantages? and why not just index fields separately? can any body explain me in simple terms.
Upvotes: 0
Views: 236
Answers (1)
Marco
Reputation: 57593
If you have to query using a composite WHERE (say on two different fields) a composite index should be faster than having two single indexes...
This is a general answer, anyway you should analyze any single query...
Upvotes: 1
Related Questions
- How do composite indexes work?
- When should I use a composite index?
- How composite index and left join work in MySql?
- Composite indexing
- What does means cardinality in MySQL when use composite index?
- MySql composite index
- Is primary key also index?
- Implementing a composite index
- Composite index
- Do composite indexes in MySql work both ways round?