Level 1
Level 2
Sign in to Community
Learn more
Sign in to view all badges
Expand my Community achievements bar.
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.
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
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
Views
Likes
Replies