On Sat, 4 Jun 2016 Andrew Beverley wrote:
> I'm performing a query with many joins, with a WHERE condition on the
> "root" table. As far as I am aware, each join is indexed, as is the
> WHERE clause. To my simple mind, this is just a case of taking a set
> of conditional indexed values, and then "
On Sat, 4 Jun 2016 Andrew Beverley wrote:
> When I run EXPLAIN ANALYZE, I see that the actual query is scanning
> significantly more rows for the join than was estimated. There is also
> a huge number of loops for the joins. Why is this, and is there an
> easy fix?
I should have said: PostgreSQL
