When searching for any term, earlier Magento by default search_tmp_* table (memory table) was created run time. Whereas in Magento 2.3.2 it is not generating search_tmp_* table when using Elastic Search 6 as Catalog Search Index.

Does anyone know whether it is removed from Magento 2.3.2 or anything missing from the configuration?

went through some of the below links but not getting exact idea. https://github.com/magento/magento2/issues/15545

magento2 search_tmp join leads to empty results in category listing

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.