same.
HTH, Cor
- Original Message - From: "Eugene Kosov" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, June 21, 2006 2:58 PM
Subject: Index on MERGE table
Hi everyone!
I have a bunch of MyISAM tables and one MERGE table. All have same
structure. It seems to me indecies
Kosov" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, June 21, 2006 2:58 PM
Subject: Index on MERGE table
Hi everyone!
I have a bunch of MyISAM tables and one MERGE table. All have same
structure. It seems to me indecies on MERGE table aren't fine. When I
fetch rows by indexed field I
omthing strange.
Index cardinality is 81 while table contains over than 12 millions of
different values.
I've tried recreating indecies but this didn't help.
I couldn't find anything relevant in documentation.
How should I create index on MERGE table?
Thanks in advance!
--
Re
> -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
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 ME
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
