In Magento2, For Admin Product Grids, Search by keyword logic is not working effectively when catalog size is bigger. (>= 25 lacs)
Due to its searching logic:
- Searching by SKU
- Searching by Product Name
- Searching in short desc, desc (when a full-text search is enabled)
- Other attributes which have property is_searchable is set
If we want to Restrict Search by keyword only looks for Sku for Product Grid.
What is the best way for doing this without attributes update (via is_searchable property)?