Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!
SOLVED

How to Disable Indexes in Import workflows?

Avatar

Level 1

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.

1 Accepted Solution

Avatar

Correct answer by
Level 1

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 solution in original post

2 Replies

Avatar

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

Avatar

Correct answer by
Level 1

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!