List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:May 7 2012 7:31am
Subject:Re: Why is creating indexes faster after inserting massive data rows?
View as plain text  
which version of mysql  are you using.

Is this secondary index.?



On Mon, May 7, 2012 at 12:07 PM, Zhangzhigang <zzgang_2008@stripped>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.
>
Thread
• Why is creating indexes faster after inserting massive data rows?Zhangzhigang7 May
  • Re: Why is creating indexes faster after inserting massive data rows?Ananda Kumar7 May
    • 回复： Why is creating indexes faster after inserting massive data rows?Zhangzhigang7 May
  • Re: Why is creating indexes faster after inserting massive data rows?Johan De Meersman7 May
    • 回复： Why is creating indexes faster after inserting massive data rows?Zhangzhigang7 May
      • Re: 回复： Why is creating indexes faster after inserting massive data rows?Alex Schaft7 May
        • 回复： 回复： Why is creating indexes faster after inserting massive data rows?Zhangzhigang7 May
          • Re: 回复： 回复： Why is creating indexes faster after inserting massive data rows?Claudio Nanni7 May
            • too nice not to share it!hsv2 Oct
          • Re: 回复： 回复： Why is creating indexes faster after inserting massive data rows?Mihamina Rakotomandimby30 May
      • Re: 回复： Why is creating indexes faster after inserting massive data rows?Claudio Nanni7 May
        • 回复： 回复： Why is creating indexes faster after inserting massive data rows?Zhangzhigang7 May
      • Re: 回复： Why is creating indexes faster after inserting massive data rows?Johan De Meersman7 May
        • RE: 回复： Why is creating indexes faster after inserting massive data rows?Rick James7 May
        • Re: 回复： Why is creating indexes faster after inserting massive data rows?Karen Abgarian7 May
          • 回复： 回复： Why is creating indexes faster after inserting massive data rows?Zhangzhigang8 May
            • Re: 回复： 回复： Why is creating indexes faster after inserting massive data rows?Karen Abgarian8 May
              • 回复： 回复： 回复： Why is creating indexes faster after inserting massive data rows?Zhangzhigang8 May
                • Re: 回复： 回复： 回复： Why is creating indexes faster after inserting massive data rows?Johan De Meersman8 May
                  • 回复： 回复： 回复： 回复： Why is creating indexes faster after inserting massive data rows?Zhangzhigang8 May
                  • Re: 回复： 回复： 回复： Why is creating indexes faster after inserting massive data rows?Karen Abgarian8 May
                    • 回复： 回复： 回复： 回复： Why is creating indexes faster after inserting massive data rows?Zhangzhigang9 May
              • RE: 回复： 回复： Why is creating indexes faster after inserting massive data rows?Rick James10 May
            • Re: 回复： 回复： Why is creating indexes faster after inserting massive data rows?Johan De Meersman8 May
        • Re: 回复： Why is creating indexes faster after inserting massive data rows?Karen Abgarian7 May
    • RE: Why is creating indexes faster after inserting massive datarows?Rick James7 May
      • 回复： Why is creating indexes faster after inserting massive data rows?Zhangzhigang9 May
        • RE: 回复： Why is creating indexes faster after inserting massive data rows?Rick James9 May
          • Re: 回复： Why is creating indexes faster after inserting massive data rows?Claudio Nanni9 May
          • 回复： 回复： Why is creating indexes faster after inserting massive data rows?Zhangzhigang10 May