> -Original Message-
> From: Sergei Golubchik [mailto:serg@;mysql.com]
> Sent: 10 November 2002 12:23
> To: Christian Sylvestre
> Cc: [EMAIL PROTECTED]
> Subject: Re: SELECT slow after adding INDEX on MERGE table
>
>
> Hi!
>
> What is the query, and w
I have 3 identical tables with approx 150,000 row each. These tables
have currently no indexes. If I do a specific query on each table it
takes approx 3 seconds per table. Doing the same query on the MERGE
tables takes approx 8.5 seconds.
I then created an index on the tables (identical index on e
