From 263b259b276edd075b0abcd6aad0e923230c2d15 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Fri, 7 Dec 2018 02:22:20 +0100
Subject: Various speed optimizations

---
 data/sql/commit.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'data/sql/commit.sql')

diff --git a/data/sql/commit.sql b/data/sql/commit.sql
index 346c5b76..7aa91e8e 100644
--- a/data/sql/commit.sql
+++ b/data/sql/commit.sql
@@ -1,5 +1,14 @@
 COMMIT;
 
+CREATE INDEX geodetic_crs_datum_idx ON geodetic_crs(datum_auth_name, datum_code);
+CREATE INDEX geodetic_datum_ellipsoid_idx ON geodetic_datum(ellipsoid_auth_name, ellipsoid_code);
+CREATE INDEX supersession_idx ON supersession(superseded_table_name, superseded_auth_name, superseded_code);
+CREATE INDEX deprecation_idx ON deprecation(table_name, deprecated_auth_name, deprecated_code);
+CREATE INDEX helmert_transformation_idx ON helmert_transformation(source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code);
+CREATE INDEX grid_transformation_idx ON grid_transformation(source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code);
+CREATE INDEX other_transformation_idx ON other_transformation(source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code);
+CREATE INDEX concatenated_operation_idx ON concatenated_operation(source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code);
+
 -- Do an explicit foreign_key_check as foreign key checking is a no-op within
 -- a transaction. Unfortunately we can't ask for this to be an error, so this
 -- is just for verbose output. In Makefile, we check this separately
-- 
cgit v1.2.3

