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.
Solved! Go to Solution.
Views
Replies
Total Likes
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!
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
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!