How can we help you today? How can we help you today?

prompt refresh suggestions blocking by alter index

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?
arian
0

Comments

1 comment

Sort by
  • Alex B
    Hi @arian

    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
    Alex B
    0

Add comment

Please sign in to leave a comment.