| Index: trunk/extensions/Wikidata/Database scripts/Convenience/Create uw_defined_meaning indices.sql |
| — | — | @@ -6,7 +6,8 @@ |
| 7 | 7 | ADD INDEX `versioned_start_expression` (`add_transaction_id`, `expression_id`, `defined_meaning_id`), |
| 8 | 8 | ADD INDEX `versioned_start_meaning_text` (`add_transaction_id`, `meaning_text_tcid`, `defined_meaning_id`), |
| 9 | 9 | ADD INDEX `defining_expression_idx` (`defined_meaning_id`,`expression_id`), |
| 10 | | - ADD INDEX `defined_meaning_idx` (`defined_meaning_id`); |
| | 10 | + ADD INDEX `defined_meaning_idx` (`defined_meaning_id`), |
| | 11 | + ADD INDEX `defining_expression_exp_idx` (`expression_id`); |
| 11 | 12 | -- ADD INDEX `unversioned_meaning` (`defined_meaning_id`, `expression_id`), |
| 12 | 13 | -- ADD INDEX `unversioned_expression` (`expression_id`, `defined_meaning_id`), |
| 13 | 14 | -- ADD INDEX `unversioned_meaning_text` (`meaning_text_tcid`, `defined_meaning_id`); |