Subject Re: TempDirectories and ALTER INDEX ACTIVE
Author Dmitry Yemanov
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 them into the
b-tree "in order".


Dmitry