We are trying to create the text indexes on our already created collections. We have text based search and aggregate takes 3 seconds to fetch just a set of 10 records.
We tried creating indexes with below MongoDB compass, nodejs (mongoose), python(pymongo) but in all the cases, index is not getting created. MongoDB deployed on AWS, collection is having only one document, but still index is not created.
Your inputs will be appreciated.
Thanks in advance for the support!