Re: Question on bad execution plan
Posted by:
Zw Zhu
Date: June 28, 2010 02:39AM
The result is as follows:
mysql> SHOW TABLE STATUS LIKE 'letter'\G
*************************** 1. row ***************************
Name: letter
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 56
Avg_row_length: 292
Data_length: 16384
Max_data_length: 0
Index_length: 16384
Data_free: 0
Auto_increment: NULL
Create_time: 2010-06-17 09:45:19
Update_time: NULL
Check_time: NULL
Collation: gbk_chinese_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.00 sec)
mysql> SHOW CREATE TABLE letter \G
*************************** 1. row ***************************
Table: letter
Create Table: CREATE TABLE `letter` (
`id` int(11) NOT NULL,
`date` date DEFAULT NULL,
`title` varchar(8) DEFAULT NULL,
`sender_name` varchar(8) DEFAULT NULL,
`sender_id` int(11) DEFAULT NULL,
`is_read` int(11) DEFAULT NULL,
`receiver_id` int(11) DEFAULT NULL,
`receiver_del` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `letter_receiver_id_receiver_del_is_read_id_desc` (`receiver_id`,`receiver_del`,`is_read`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk
1 row in set (0.00 sec)