We are using Dynamics CRM 2016 on-prem
We are looking at how to improve searching over our product catalog which has something like 150k products in it. So I enabled full-text indexing to test the Quick Find capability. Initially this worked but during testing I realised that although there were multiple columns specified, results are only returned for rows where a complete match can be satisfied from one column. So for example, if I search for "Microsoft Dynamics CRM" it will not return the a row where the Vendor is "Microsoft" and the Name is "Dynamics CRM" even though both fields are in the index. This can be verified by checking the query that is generated.
So I switched off full text indexing and created a new column which is a concatenation of all the values we are interested in so the search can be satisfied from a single field I'm using a calculated field to do this. I then added the field to the Quick Find find columns and switched on full text indexing again, wait 24 hours...
The system creates a bunch of full text indexes on a number of entities - but nothing for ProductBase.
I have now been through several cycles of disabling full text indexes, changing the find fields and re-enabling to try to determine whether it's specific to the fields selected.
Nothing seems to work.
I have used the job editor to reschedule the Indexing Management job to try to make sure it's running and I have tried running the p_Reindex and p_ReindexAll sp's (but these don't create missing indexes they just build what's there). The p_Reindex sp actually fails with an exception (Could not find any index named 'ThemeBase_FullText' for table 'ThemeBase'.) because the metadata in the CRM database includes entries for full text indexes that have not been created in the SQL database.
So now I'm stumped - I can find no information on how the full text indexes are managed and so I've got very little to go on to work around the issue.
Any ideas welcomed!
