…date` datetime NOT NULL default ’0000-00-00 00:00:00′, `comment_date_gmt` datetime…only 3 distinct values in the table for this column, so its not actually counting the values but the pointers from this index: mysql…
Comment: How to find wrong indexing with glance view
March 8, 2010 By 27 Comments
…only do these indexes slow down insert operations, the MySQL optimizer sometimes appears to become rather overwhelmed by the number of indexes…date datetime not null, last_updated timestamp not null default current_timestamp on update current_timestamp, foreign key(item_type_id) references item_types…
