• Home
• io.nflow
• nflow-engine
• 7.2.0
• source code
• sqlserver.update.ddl.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

scripts.db.update-7.1.0-x.sqlserver.update.ddl.sql Maven / Gradle / Ivy

drop index nflow_archive_workflow_uniq;

create index idx_workflow_archive_type on nflow_archive_workflow(type);

drop index nflow_archive_workflow_parent;

CREATE INDEX WITH (DROP_EXISTING = ON, ONLINE = ON) idx_workflow_parent on nflow_workflow(parent_workflow_id) where parent_workflow_id is not null;

CREATE INDEX WITH (DROP_EXISTING = ON, ONLINE = ON) idx_workflow_archive_parent on nflow_archive_workflow (parent_workflow_id) where parent_workflow_id is not null;