We've done bulk indexing of production multiple times with various configurations - currently we have it backed out and have deleted the results. Can discuss our experience w/you if you like.
Primary issues:
1. Our primary use case is to find "where used" info for any typed-in document / part number. When there are indexing failures there is no way to find out which objects they are - and so no way to trust that searches are complete.
2. We've seen inconsistent, bizarre results with wildcards when indexing is enabled. Have also done many tests with a large number of criteria - hard to get confidence in the results when indexing is added to the mix.
3. When indexing is enabled, users have to change their preference each time they want to use it - quite a few clicks. Would be much better if the default was not to use the index search and users could check a box if they wanted to.
Searching here
[cid:image001.png@01CF7341.2630BAF0]
results in the entered value here
[cid:image002.png@01CF7341.2630BAF0]