From: Zhangzhigang Date: May 7 2012 6:37am Subject: Why is creating indexes faster after inserting massive data rows? List-Archive: http://lists.mysql.com/mysql/227330 Message-Id: <1336372671.81050.YahooMailNeo@web15202.mail.cnb.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-404248122-450167553-1336372671=:81050" ---404248122-450167553-1336372671=:81050 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable hi all:=0A=0AI have a question:=0A=0ACreating indexes after inserting massi= ve data rows is faster than before inserting data rows.=0APlease tell me wh= y. =0A ---404248122-450167553-1336372671=:81050--