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 a...@zeit.io > On 08-Apr-2019, at 4:36 PM, mariusz <mar...@mtvk.pl> 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)
