In the last episode (Aug 30), Kyong Kim said:
I've been going through the 5.1 manual and exploring the new features.
To add a secondary index to an existing table, InnoDB scans the table, and
sorts the rows using memory buffers and temporary files in order by the
value(s) of the secondary
I've been going through the 5.1 manual and exploring the new features.
To add a secondary index to an existing table, InnoDB scans the table,
and sorts the rows using memory buffers and temporary files in order
by the value(s) of the secondary index key column(s). The B-tree is
then built in