diff options
| author |   danielhanrahan <daniel.hanrahan@est.tech> | 2023-03-07 16:56:08 +0000 |
|---|---|---|
| committer | Daniel Hanrahan <daniel.hanrahan@est.tech> | 2023-03-08 08:41:15 +0000 |
| commit | 38d3064bcb92ed175f2e3b83b10b12c822dfe811 (patch) | |
| tree | 53fb7527fb59218a142be242cfe1990a00f3bba8 /cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml | |
| parent | 29b493f8859f1ce0eeadaba75462006499f6f26d (diff) | |
Add index to schema_set_yang_resources table
Currently, the database is sequentially scanning when deleting from
schema_set_yang_resources table as there are no indexes on the table.
Adding an index doubles performance of NCMP CM-handle deregistration.
Issue-ID: CPS-1535
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
Change-Id: Ia6ac7ef95d1662f49a77fc72112f1e29a67079ff
Diffstat (limited to 'cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml')
| -rw-r--r-- | cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml b/cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml new file mode 100644 index 0000000000..bc16725109 --- /dev/null +++ b/cps-ri/src/main/resources/changelog/db/changes/17-add-index-to-schema-set-yang-resources.yaml @@ -0,0 +1,15 @@ +databaseChangeLog: + - changeSet: + author: cps + id: 17 + changes: + - createIndex: + columns: + - column: + name: schema_set_id + indexName: FKI_SCHEMA_SET_YANG_RESOURCES_SCHEMA_SET_ID_FK + tableName: schema_set_yang_resources + rollback: + - dropIndex: + indexName: FKI_SCHEMA_SET_YANG_RESOURCES_SCHEMA_SET_ID_FK + tableName: schema_set_yang_resources |