From 263b259b276edd075b0abcd6aad0e923230c2d15 Mon Sep 17 00:00:00 2001 From: Even Rouault 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