Hi, Thanks for showing different ways to achieve the goal. So what should be the optimal way to solve this. I have an composite index using company_id and feature_id columns for project_features table. I do ruby on rails development, where table names are plural always by convention. The tables I created above in different schema to ask question with sample data and test the query output. So they are little inconsistent, yes you are right. Thanks, Arup Rakshit ar@xxxxxxx > On 08-Apr-2019, at 4:36 PM, mariusz <marius@xxxxxxx> wrote: > > bear in mind that with a large number of companies and proper index on > company_features the optimizer could limit company_features as > necessary, while your examples read everything anyway and mangle output > to get proper result (with dups and bugs, but also not optimal)
