prompt refresh suggestions blocking by alter index

arianarian Posts: 1 New member
edited April 9, 2019 12:17PM in SQL Prompt
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?

Answers

  • Alex BAlex B Posts: 1,153 Diamond 4
    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.