Re: Selecting a 80 million regs database ordered by an Index

[lei liang]

ALTER TABLE table1 ADD INDEX index_name(orderby_index_column);
create table ble (select * from table1 limit 0);
insert into ble select * from table1 order by index limit 0,100000;
insert into ble select * from table1 order by index limit 100000,200000;
...