Re: Adding an index caused problems!

[Quoted] Without index:

1,SIMPLE,p,,ALL,,,,,992931,100.00,Using temporary; Using filesort

With index on state:

1,SIMPLE,p,,index,inx_state,inx_state,258,,992931,100.00,

With index took 2 minutes to return result set. Received on Wed May 22 2019 - 20:37:00 CEST