How to Disable Indexes in Import workflows? | Community

swapnilbhiungade7

Solved

How to Disable Indexes in Import workflows?

Forum|Forum|3 years ago
June 22, 2022
1 reply
739 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by swapnilbhiungade7

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!

Adobe Employee

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

swapnilbhiungade7AuthorAccepted 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!