Is there a use scenario we need to create two covering index on the same set of fields in MySQL?

Posted by symfony on Stack Overflow See other posts from Stack Overflow or by symfony
Published on 2010-03-23T13:58:01Z Indexed on 2010/03/23 14:23 UTC
Read the original article Hit count: 406

create index i_t_a_b on t(a,b);

create index i_t_b_a on t(b,a);

© Stack Overflow or respective owner