mysql> SHOW INDEX FROM core_url_rewrite;
+------------------+------------+------------------------------------------------------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Visible | Expression |
+------------------+------------+------------------------------------------------------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
| core_url_rewrite | 0 | PRIMARY | 1 | url_rewrite_id | A | 702072 | NULL | NULL | | BTREE | | | YES | NULL |
| core_url_rewrite | 0 | UNQ_CORE_URL_REWRITE_REQUEST_PATH_STORE_ID | 1 | request_path | A | 605248 | NULL | NULL | YES | BTREE | | | YES | NULL |
| core_url_rewrite | 0 | UNQ_CORE_URL_REWRITE_REQUEST_PATH_STORE_ID | 2 | store_id | A | 645476 | NULL | NULL | | BTREE | | | YES | NULL |
| core_url_rewrite | 0 | UNQ_CORE_URL_REWRITE_ID_PATH_IS_SYSTEM_STORE_ID | 1 | id_path | A | 702271 | NULL | NULL | YES | BTREE | | | YES | NULL |
| core_url_rewrite | 0 | UNQ_CORE_URL_REWRITE_ID_PATH_IS_SYSTEM_STORE_ID | 2 | is_system | A | 702271 | NULL | NULL | YES | BTREE | | | YES | NULL |
| core_url_rewrite | 0 | UNQ_CORE_URL_REWRITE_ID_PATH_IS_SYSTEM_STORE_ID | 3 | store_id | A | 700064 | NULL | NULL | | BTREE | | | YES | NULL |
| core_url_rewrite | 1 | IDX_CORE_URL_REWRITE_TARGET_PATH_STORE_ID | 1 | target_path | A | 39958 | NULL | NULL | YES | BTREE | | | YES | NULL |
| core_url_rewrite | 1 | IDX_CORE_URL_REWRITE_TARGET_PATH_STORE_ID | 2 | store_id | A | 39958 | NULL | NULL | | BTREE | | | YES | NULL |
| core_url_rewrite | 1 | IDX_CORE_URL_REWRITE_ID_PATH | 1 | id_path | A | 702271 | NULL | NULL | YES | BTREE | | | YES | NULL |
| core_url_rewrite | 1 | IDX_CORE_URL_REWRITE_STORE_ID | 1 | store_id | A | 1 | NULL | NULL | | BTREE | | | YES | NULL |
| core_url_rewrite | 1 | FK_CORE_URL_REWRITE_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID | 1 | category_id | A | 182 | NULL | NULL | YES | BTREE | | | YES | NULL |
| core_url_rewrite | 1 | FK_CORE_URL_REWRITE_PRODUCT_ID_CATALOG_CATEGORY_ENTITY_ENTITY_ID | 1 | product_id | A | 5788 | NULL | NULL | YES | BTREE | | | YES | NULL |
+------------------+------------+------------------------------------------------------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+