Re: Adding an index caused problems!
From: Richard Ryan <rich_at_turftechno.com>
Date: Wed, 22 May 2019 11:53:02 -0700 (PDT)
Message-ID: <b8b5465f-a96f-429e-a72b-5f26fe1f75ee_at_googlegroups.com>
Date: Wed, 22 May 2019 11:53:02 -0700 (PDT)
Message-ID: <b8b5465f-a96f-429e-a72b-5f26fe1f75ee_at_googlegroups.com>
On Wednesday, May 22, 2019 at 2:37:02 PM UTC-4, Richard Ryan wrote:
> 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.
[Quoted] Version: MySQL 7.7.24
Engine: innoDB
Received on Wed May 22 2019 - 20:53:02 CEST