prompt refresh suggestions blocking by alter index
arian
Posts: 1 New member
Hi
I execute "alter index" in heavy and big table.
I want to use refresh suggestion with "Ctrl+shift+d". it does not work, because it's blocked by "alter index".
Is there any way to resolving this issue?
I execute "alter index" in heavy and big table.
I want to use refresh suggestion with "Ctrl+shift+d". it does not work, because it's blocked by "alter index".
Is there any way to resolving this issue?
Tagged:
Answers
If the queries that are run to refresh the suggestions are being blocked by another query there's not a lot we can do - we need to be able to run those queries to perform the refresh action.
You may be able to add the ONLINE keyword to the ALTER INDEX so that other queries will still function - but that would cause the index operation to take longer.
I hope that helps!
Kind regards,
Alex
Have you visited our Help Center?