Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

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