Re: Adding an index caused problems!
From: Richard Ryan <rich_at_turftechno.com>
Date: Wed, 22 May 2019 11:37:00 -0700 (PDT)
Message-ID: <1c6d9bb1-cec6-436d-90d0-00ca3e689f88_at_googlegroups.com>
Date: Wed, 22 May 2019 11:37:00 -0700 (PDT)
Message-ID: <1c6d9bb1-cec6-436d-90d0-00ca3e689f88_at_googlegroups.com>
[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