Explain Query (mysql)
EXPLAIN SELECT DISTINCT(hd_product_id) FROM droppoints WHERE hd_product_id IS NOT NULL
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | droppoints | range | fk_dp_hd_product, droppoints_idx_droppoint_id_hd_id | fk_dp_hd_product | 5 | 1 | 100.00 | Using where; Using index for group-by |