Skip to main content
swapnilbhiungade7
Jun 22, 2022 5:44 AM UTC
Solved

How to Disable Indexes in Import workflows?

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.
swapnilbhiungade7Accepted solution
Jul 5, 2022 6:28 AM UTC

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!

View in thread

2 replies

Adobe Employee
dsareen1Adobe Employee
Adobe Employee
Jun 27, 2022 12:59 PM UTC

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

Translate
    swapnilbhiungade7AuthorAccepted solution
    Jul 5, 2022 6:28 AM UTC

    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!

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...