Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.4.6
-
None
-
Linux Ubuntu
Description
I have a table with 115 MM records. One field is varchar(50) and it has two possible values , either "business" or "residential". It is indexed.
This simple query takes forever,
select x from table where recordtype='business'
explain select number from table where recordtype='business';
----------------------------------------------------------------------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
----------------------------------------------------------------------------------------------------------------+
| 1 | SIMPLE | table | ref | IDX_table_recordtype | IDX_table_recordtype | 54 | const | 1115827 | Using index condition |
----------------------------------------------------------------------------------------------------------------+
It used to work fine in older versions. Now I am changing back to Innodb.
I already did "optimize table" and it did not make it faster