Rick James Wrote:
-------------------------------------------------------
> In addition to Peter's toned down request, ...
>
> Let's see the EXPLAIN for that SELECT.
>
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
_tbl1 InnoDB 10 Compact 3666243 210 771751936 0 874053632 1432354816 3669961 3/3/2011 16:51:51 latin1_swedish_ci
_tbl2 InnoDB 10 Compact 9395 392 3686400 0 1310720 1432354816 9291 20/6/2011 14:43:38 latin1_swedish_ci
> ALTER TABLE _tbl2
> ADD INDEX(MCR_Cod, MCR_Clt, MCR_Den);
[SQL] ALTER TABLE _tbl2
ADD INDEX(MCR_Cod, MCR_Clt, MCR_Den);
Affected rows: 9290
Time: 1.741ms
In MySQL:
Affected rows: 0
Time: 82.387ms
In browser:
Affected rows: 0
Time: 124.113ms
thks