Yes. Those keys are redundant. -----Original Message----- From: Cemal Dalar To: Group MySQL List Sent: 8/13/04 7:12 AM Subject: Indexes
mysql> show index from urun; +-------+------------+------------------+--------------+-------------+-- ---- -----+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +-------+------------+------------------+--------------+-------------+-- ---- -----+-------------+----------+--------+------+------------+---------+ | urun | 0 | PRIMARY | 1 | urun_id | A | 108725 | NULL | NULL | | BTREE | | | urun | 0 | UC_urun_id | 1 | urun_id | A | 108725 | NULL | NULL | | BTREE | | | urun | 1 | IDX_urun_urun_id | 1 | urun_id | A | 108725 | NULL | NULL | | BTREE | | | urun | 1 | ktgr | 1 | ktgr | A | 512 | NULL | NULL | | BTREE | | +-------+------------+------------------+--------------+-------------+-- ---- -----+-------------+----------+--------+------+------------+---------+ 4 rows in set (0.00 sec) Also my "show create table urun" looks like this.. ...... PRIMARY KEY (`urun_id`), UNIQUE KEY `UC_urun_id` (`urun_id`), KEY `IDX_urun_urun_id` (`urun_id`), KEY `ktgr` (`ktgr`) ) TYPE=MyISAM | Isn't this "KEY `IDX_urun_urun_id` (`urun_id`)," and "UNIQUE KEY `UC_urun_id` (`urun_id`)," indexes are unnecessary? Best Regards, Cemal Dalar a.k.a Jimmy System Administrator & Web Developer http://www.dalar.net -- 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]
