Hi Eugene,
I suppose you have read:
http://dev.mysql.com/doc/refman/5.0/en/merge-table-problems.html
Especially the paragraph starting with:
The order of indexes in the MERGE table and its underlying tables should be
the same.
HTH, Cor
----- Original Message -----
From: "Eugene Kosov" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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 get empty result set. Index size showed by
'SHOW TABLE STATUS' is 0. SHOW INDEXES also shows somthing 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!
--
Regards,
Eugene Kosov.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]