view schema/updates/1107/01.reindex_import_logs.sql @ 4187:65a5501dc13d

Enable faster access to import logs Import logs are accessed per import. Index accordingly and leverage index usage in respective SQL statements.
author Tom Gottfried <tom@intevation.de>
date Wed, 07 Aug 2019 10:27:11 +0200
parents
children
line wrap: on
line source

DROP INDEX import.kind_idx;
CREATE INDEX import_logs_import_id ON import.import_logs (import_id);