diff options
Diffstat (limited to 'ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/02_create_indexes_ddl.sql')
-rw-r--r-- | ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/02_create_indexes_ddl.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/02_create_indexes_ddl.sql b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/02_create_indexes_ddl.sql new file mode 100644 index 00000000..65562424 --- /dev/null +++ b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/02_create_indexes_ddl.sql @@ -0,0 +1,8 @@ +--liquibase formatted sql +--changeset index_creation:18_10.create_indexes_01.sql + +-- Add indexes on GENERATED_NAME + +create index gen_name_ext_id_idx on GENERATED_NAME(EXTERNAL_ID); +create index gen_name_name_idx on GENERATED_NAME(NAME); +create index gen_name_pre_suf_idx on GENERATED_NAME(PREFIX, SUFFIX); |