From f167d3fa6e3922bbfe92315e8e8d7ec0bf0ffa2b Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Thu, 14 May 2020 22:01:56 +0200 Subject: Database: add index on alias_name(code) --- data/sql/proj_db_table_defs.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'data/sql') diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index df20de31..2d820d20 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -1340,6 +1340,8 @@ CREATE TABLE alias_name( source TEXT ); +CREATE INDEX idx_alias_name_code ON alias_name(code); + CREATE TRIGGER alias_name_insert_trigger BEFORE INSERT ON alias_name FOR EACH ROW BEGIN -- cgit v1.2.3