How to Disable Indexes in Import workflows?

[swapnilbhiungade7]

Hello,

I want to Disable some of the indexes and in some cases all of the indexes used in schema while using import workflows, how can I do this.

Help will be greatly appreciated

Thanks.

[dsareen1]

Hi Swapnil,

In ACC index disabling can happen at DB or schema definition level.

I don't think we can do it at runtime in workflows.

Thanks,

Deepika

[swapnilbhiungade7 · Accepted solution]

Hello Deepika,

Thank you for reaching out.

We can do this by following SQL query.

To Disable: alter index INDEX_NAME UNUSABLE;

To Enable:  alter index INDEX_NAME REBUILD;

Thanks!