From: Ananda Kumar Date: May 7 2012 7:31am Subject: Re: Why is creating indexes faster after inserting massive data rows? List-Archive: http://lists.mysql.com/mysql/227331 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf303f6562ca9abd04bf6d40bb --20cf303f6562ca9abd04bf6d40bb Content-Type: text/plain; charset=ISO-8859-1 which version of mysql are you using. Is this secondary index.? On Mon, May 7, 2012 at 12:07 PM, Zhangzhigang wrote: > hi all: > > I have a question: > > Creating indexes after inserting massive data rows is faster than before > inserting data rows. > Please tell me why. > --20cf303f6562ca9abd04bf6d40bb--