Optimize a query SQL for Postgrsql DB

Job ID: 35360173

Budget: €12 – €18 EUR

Hello,

I have a table with 12M record and I need to optimize request on it.

I guess good index strategy can do the trick :) !

It's a 3 column table and one could be deleted so it's quite straight forward. I need to do text search on it.

Answer with GOLD to make sure that you read to desc.