Indexing Issue?

I constantly have to re-index when I change the search string.

I didn't have to re-index so much before a few months ago.

Is this a known problem and is there a solution?

Tagged:

Answers

  • Jessica RJessica R Posts: 1,319 Rose Gold 4
    Hello,

    Thanks for your post!

    I know there have been changes in the past to reduce automatic reindexing in order to avoid SSMS exhausting resources, but there haven't been any recent changes to this that I'm aware of.  (In 2018, SQL Search stopped reindexing at startup, for example.)

    Can I just confirm if you are changing the search string while SQL Search is in the process of reindexing? Or does it occur even when it's not? 

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • mdullni1mdullni1 Posts: 26 Bronze 3
    No, I am not changing the string while indexing.  I will have used SQL Search to find something, usually having to re-index first.  Later on, I will go to SQL Search to find something else in the same database, but I have to re-index or it returns unrelated objects, thousands of them, or it returns the objects from the previous search.
  • Hi @mdullni1

    That's indeed very odd. Could you check which version of SQL Search you are on?

    The log might reveal something useful. I'll reach out to you by email shortly.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.