MySQL Forums
Forum List  »  Optimizer & Parser

Re: Subqueries too slow
Posted by: Andreas Schlicker
Date: February 07, 2006 07:06AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
5030
February 06, 2006 11:08AM
2538
February 06, 2006 11:54AM
2338
February 06, 2006 02:17PM
Re: Subqueries too slow
2311
February 07, 2006 07:06AM
2328
February 07, 2006 08:38AM
2359
February 10, 2006 03:18AM
2017
February 10, 2006 08:51AM
2087
February 10, 2006 09:49AM
2238
February 10, 2006 10:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.