This is an automated email from the ASF dual-hosted git repository.
asf-gitbox-commits pushed a commit to branch geoapi-4.0
in repository https://gitbox.apache.org/repos/asf/sis.git
The following commit(s) were added to refs/heads/geoapi-4.0 by this push:
new 2ae6125a8a Add a missing index in EPSG database which was making
queries very slow. https://issues.apache.org/jira/browse/SIS-639
2ae6125a8a is described below
commit 2ae6125a8a3cafa89496bd1629033a33360aba06
Author: Martin Desruisseaux <[email protected]>
AuthorDate: Wed Oct 28 10:26:01 2026 +0100
Add a missing index in EPSG database which was making queries very slow.
https://issues.apache.org/jira/browse/SIS-639
---
.../main/org/apache/sis/referencing/factory/sql/epsg/Finish.sql | 1 +
1 file changed, 1 insertion(+)
diff --git
a/optional/src/org.apache.sis.referencing.epsg/main/org/apache/sis/referencing/factory/sql/epsg/Finish.sql
b/optional/src/org.apache.sis.referencing.epsg/main/org/apache/sis/referencing/factory/sql/epsg/Finish.sql
index b649bf65ce..24f89d1f50 100644
---
a/optional/src/org.apache.sis.referencing.epsg/main/org/apache/sis/referencing/factory/sql/epsg/Finish.sql
+++
b/optional/src/org.apache.sis.referencing.epsg/main/org/apache/sis/referencing/factory/sql/epsg/Finish.sql
@@ -41,6 +41,7 @@ CREATE INDEX ix_parameter_values ON
"Coordinate_Operation Parame
CREATE INDEX ix_parameter_value_code ON "Coordinate_Operation
Parameter Value" (parameter_code);
CREATE INDEX ix_path_concat_operation_code ON "Coordinate_Operation
Path" (concat_operation_code);
CREATE INDEX ix_supersession_object_code ON "Supersession"
(object_code);
+CREATE INDEX ix_usage_object ON "Usage"
(object_table_name, object_code);
-----------------------------------------------------------------------------
