Re: Subqueries too slow

[Andreas Schlicker]

Thanks for your quick reply.

The main reason for going with subqueries was that the SQL is generated automatically from a user query in a custom query language. The subqueries are nice building blocks that can easily be put together automatically.

Here's the information you requested:
table a:
id: primary key, 1326663 unique entries
acc: unique index, 1326663 unique entries
name: index, 2 unique entries

table b:
id: primary key, 21469479 unique entries
a_id: INDEX, 1341842 unique entries
c_id: INDEX, 6478 unique entries

table c:
id: primary key, 878 unique entries
acc: unique index, 878 unique entries

Thanks,
Andreas