Re: [firebird-support] Re: TempDirectories and ALTER INDEX ACTIVE

2012-06-10 Thread Mark Rotteveel
On 8-6-2012 18:07, Ann Harrison wrote: On Fri, Jun 8, 2012 at 11:24 AM, Alec Swan alecs...@gmail.com wrote: Thanks Vlad, but this is too complicated to give as a guidance to our customers. However, it sounds like rebuilding an index cannot require more space that the database size itself,

Re: [firebird-support] Re: TempDirectories and ALTER INDEX ACTIVE

2012-06-10 Thread Mark Rotteveel
On 10-6-2012 12:32, Dmitry Yemanov wrote: 10.06.2012 14:09, Mark Rotteveel wrote: * for each record (sequential read of all pages?) * insert column value into index Inserting unsorted / random values into the b-tree is known to be much slower than sorting the values in advance and loading