[PERFORM] Index is not using

Hi All I am facing query performance in one of my testing server. How i can create index with table column name ? EXPLAIN select xxx.* from xxx xxx where exists (select 1 from tmp where mdc_domain_reverse like xxx.reverse_pd || '.%'); QUERY PLAN -

[PERFORM] Planner sometimes doesn't use a relevant index with IN (subquery) condition

[Please CC me on replies, as I'm not subscribed; thank you.] I've ran into a problem with the query planner and IN (subquery) conditions which I suspect to be a bug. I'll attempt to describe the relevant details of my database and explain which behaviour I find unexpected. I've also tried to trigg