| Index: trunk/extensions/Wikidata/Database scripts/Convenience/Create uw_defined_meaning indices.sql |
| — | — | @@ -5,6 +5,7 @@ |
| 6 | 6 | ADD INDEX `versioned_start_meaning` (`add_transaction_id`, `defined_meaning_id`, `expression_id`), |
| 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 | + ADD INDEX `defining_expression_idx` (`defined_meaning_id`,`expression_id`), |
| 9 | 10 | ADD INDEX `defined_meaning_idx` (`defined_meaning_id`); |
| 10 | 11 | -- ADD INDEX `unversioned_meaning` (`defined_meaning_id`, `expression_id`), |
| 11 | 12 | -- ADD INDEX `unversioned_expression` (`expression_id`, `defined_meaning_id`), |