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