Missing Index on parentFk

[4DFuchs]

Hi,
I am generating the DDL with the DDL-Creator from Deegree-Project like this

final MappedAppSchema mappedSchema = getMappedSchema(new PostGISDialect("2.0.0"));

final String[] createStmts = DDLCreator.newInstance(mappedSchema, getPostGISDialect()).getDDL();

But I am confused, because the Indices for ForeignKeys are missing. This bug has big performance issue when deleting or selecting rows in the database.

In my opinion the index should be generated after the call of createJoinedTable.

[tfr42]

The deegree CLI and its underlying API provides functions to generate SQL DDL scripts based on GML application schemas. Currently there is no function or option available to enable the creation of database indexes by default. Users are advised to manually add indexes appropriate to the usage scenario.

You may consider to post your feedback also to issue #977 which is about performance improvements for SQLFeatureStore based WMS.

We appreciate any contribution to the deegree code base which adds this kind functionality.