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: 408
mysql
|covering-index
When will the below be necessary:
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