How to make a query to search 6 columns in one table and 1 column in another(there is a non-optimized query with ILIKE)?
There are more than 13 million records in the table. This request is processed in 80 seconds. Which is a very long time. Since ILIKE is used, indexing does not work. How can I optimize my query? Maybe I need to create a FULL TEXT INDEX for all fields?