Re-organizing Full-Text catalog

Question

Re-organizing Full-Text catalog

indianscorpion29

Right there with Babe

Points: 750
More actions
September 10, 2014 at 3:48 am

#296081

Hi All,
I am in a dilemma if I should reorganize or rebuild a full text catalog.
My application owner does not want a rebuild as he says that it takes week for the rebuild to occur on these full text indexes.
Will this code just re-organize without turning off the full text indexes :
Alter fulltext catalog catalog_name
Reorganize
Tried searching a lot on the internet and could not find any dependable answer. Would really appreciate any assistance here.
thanks in advance.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 1

I don't see anything for reorganize, but this piece says queries still run with rebuild, so I suspect things will be fine, albeit, potentially slower

http://blogs.msdn.com/b/sqlcat/archive/2008/11/06/best-practices-for-integrated-full-text-search-ifts-in-sql-2008.aspx

Do you have automatic updates turned on for FTS?

indianscorpion29 Right there with Babe Points: 750 More actions · Answer 2

Thanks Steve.

However, This is sort of getting on my nerves and the app owner specifically asked me NOT to rebuild FT catalog.

Is there any reason that I should not be doing just the reorganize?

thanks,

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 3

Off hand, no, but YMMV.

I assume the FTS reorganize/rebuild is like the regular index process, but I could be wrong here. I'll ask the question.

If it's the same, then reorganize will move pages around a couple at a time. So your index doesn't change, but it tries to clear fragmentation, which can impact query performance (more reads / query). However if you stop it, all your work remains as these are tiny transactions.

For Rebuild, if it drops the index, I would guess that your queries slow way down (or fail) as the index is rebuilt. I would guess this is one transaction, but I could be wrong. If so, then stopping it undoes all your work. However the index should be much more compact and perform better.

As I said, depending on the size of your index, I'm not sure this matters. Can I ask what the issue is? Are you missing docs from the queries or is it just slow?

indianscorpion29 Right there with Babe Points: 750 More actions · Answer 4

Hi Steve,

ITs not slow or anything, Infact the database is in its nascency stage still.

Its just that they've asked me to setup maintenance plans for this database and they specifically asked me to not Rebuild full text indexes and they just asked me to do a ReOrganize on it.