Tag: full text search

Recently a client came to me asking “How do we verify if a full text search index is being used on MongoDB?” The db.showIndexes() command shows an index on a text field, but explain() shows COLLSCAN and the query is…

Vitor Fava, SQL Server Database Consultant at Pythian, explains how to optimize text searches in SQL Server 2014 by using Full-Text Search.