Hi Brothers and Sisters, I need to know how to optimazion index in MySQL, i was read on the manual, but i did not found solution.
My case, i have a 20 million record on the one table, yhe table name TABLE_1 i have a field on TABLE_! as indexed and primary key named FIELD_1 (varchar(64) not null ) my structure like this CREATE TABLE `TABLE_1`( `FIELD_1` varchar(64) NOT NULL default '', `FIELD_2` varchar(16) NOT NULL default '', `FIELD_3` varchar(150) default NULL '', PRIMARY KEY (`FIELD_1`), KEY `FIELD_1` (`FIELD_1`), ) TYPE=MyISAM PACK_KEYS=1 but, i do query sintax, just simple .... select count(*) from TABLE_1 where FIELD_1 = "XXX_CC"; But i got the result very long time....more 10 minutes I used Sun Solarys with 2 Gygabyte RAM. What wrong with my strusture database... thank's for your answer, i with you always fine and happiness Best Regard, Hery Yulianto --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php