Re: [MonetDB-users] Problem with running TPC-H query No.5

I did the same explain and found 7 idx's used. You only have 4, ie I don't think you have all foreign keys defined.

You are right, I have omitted one constraint on the lineitem table. Thanks.