-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 what does EXPLAIN say ?
The query is:
SELECT
Hi!
What is the query, and what does EXPLAIN say ?
On Nov 08, Christian Sylvestre wrote:
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
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