Re: [GENERAL] what happens when concurrent index create

2012-04-04 Thread Albe Laurenz
leo xu wrote: > i read documents,i find it that concurrent index create don't lock write.but > need scan table twice.it explain is following as: >It scans the table once to initially build the index, then makes a second > pass to look for things added after the first pass. > > please explain 1

Re: [GENERAL] what happens when concurrent index create

2012-04-03 Thread Raghavendra
On Tue, Apr 3, 2012 at 9:50 PM, leo xu wrote: > i read documents,i find it that concurrent index create don't lock > write.but > need scan table twice.it explain is following as: > It scans the table once to initially build the index, then makes a second > pass to look for things added after th

[GENERAL] what happens when concurrent index create

2012-04-03 Thread leo xu
i read documents,i find it that concurrent index create don't lock write.but need scan table twice.it explain is following as: It scans the table once to initially build the index, then makes a second pass to look for things added after the first pass. please explain 1. what happens when concu