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.