| Subject | Re: TempDirectories and ALTER INDEX ACTIVE | 
|---|---|
| Author | hvlad | 
| Post date | 2012-06-11T06:30:21Z | 
> It might be worth to investigate this tradeoff, or just to provide anYou already can do it by yourself. Run and compare
> option to rebuild indices without using temporary sort spaces so others
> can measure it for themselves (or to have a workaround if disk space is
> not large enough to accommodate the rebuild).
1. good and fast
- create table
- insert a lot of records
- create index
and
2. bad and slow
- create table
- create index
- insert a lot of records
Regards,
Vlad