diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2018-12-07 02:22:20 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2018-12-07 18:22:28 +0100 |
| commit | 263b259b276edd075b0abcd6aad0e923230c2d15 (patch) | |
| tree | 9d58da6d9cbffd0b9f17ed1c46ea2a51ceb8a400 /data | |
| parent | cae698abe380b3823c3f08151c25097031ae091f (diff) | |
| download | PROJ-263b259b276edd075b0abcd6aad0e923230c2d15.tar.gz PROJ-263b259b276edd075b0abcd6aad0e923230c2d15.zip | |
Various speed optimizations
Diffstat (limited to 'data')
| -rw-r--r-- | data/sql/commit.sql | 9 |
1 files changed, 9 insertions, 0 deletions
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 |