With CRM 2015 UR1, Microsoft released Full Text Search. Here are FAQs related to Full Text Search:
What is Full Text Search?
This is a new feature provided by Microsoft along with CRM 2015 UR1 to improve the performance of wild card searches.
Why Full Text Search is required?
With CRM 2015, Microsoft enabled Global Search (Multi Entity Search). If you have performance issues with that, then Full Text Search is for you. It also improves the performance for wild card searches.
What benefits will my users get?
How to enable full text searches?
- Users are no longer needed to use wild cards during Quick find. e.g. searching instead of *drive, you can search directly drive.
- good performance compared to searches that uses wild cards
- It incorporate pluralization and tenses etc. during searches. e.g. If you search for drive, it will return the results with drive, drove and driven, driving etc. Also, if you search for mouse, it will return mouse, mice etc.
- If you want to search for exact match, you can use quotation mark to limit the search for an exact match. e.g. "drive", then it will not return plural and different forms of verb.
Well, it's very easy to enable the full text search. Navigate to Settings--> Administration-->System Settings.
Under Set up Quick Find section, set Enable full-text search for Quick Find to Yes. It will take almost 24 hours to create Full Text search related index and to create Full Text Catalog in SQL Server.
I enabled full text search but still it is not working. Do I need to do anything else?
If you have enabled full text search under System Settings, you should wait at least 24 hours before testing this.
If you have set EnableQuickFindOptimization to 0 by changing orgdborgsettings, Full text search will not work. To get Full Text Search working, you need to set EnableQuickFindOptimization to 1.
Full Text Search creates full text catalog in SQL Server. Where can we see this in SQL server?
To see it in SQL Server, navigate to CRM organization database-->Storage-->Full Text Catalog. Since it takes considerable amount of time (almost 24 hrs), so it won't be visible immediately.
Can we limit the number of tables for Full Text Search?
By default, when you enable the Full Text search, it is enabled for all the entities. CRM does not provide any method to limit the number of entities. However you can go to Full Text Catalog in SQL Server to remove the entities from Full Text Catalog by selecting and clicking on highlighted arrow. However, this is not supported.
How much performance improvement will I get by enabling Full Text Search?
It will depend upon multiple factors like environment, amount of customization etc. However, below image shows the performance improvement statistics provided by Microsoft. Below image taken from Microsoft presentation for full text search:
Please let me know by posting comment below how did you like this article about Full Text Search. Please also let us know your queries.