Full-text index bloat is a real thing. How to know if you've got it and what to do if you have.

Full-text index bloat is a real thing. How to know if you've got it and what to do if you have.

The Optimizer has a new 'Indexed view' that shows all databases with a full-text index and some of the key metrics about those indexes. In the screenshot below, you can see the statrep.nsf database has a full-text index that was made in October 2019, but it needs attention because it is 41% larger than the actual database, weighing in at a massive 2GB!

Fixing the issue is as easy as telling the Optimizer to rebuild it. We blogged about it here.

The end result is truly impressive, with a FTI of only 44MB.

Want to know if your servers are experiencing a similar issue? If so, click here.