I am on Oracle 11.7 on HP UNIX. I am doing some OLTP compression, As part of that
- 1.I am doing alter table mytable move.
Which moves my table (so all data is compressed) but it makes my indexes unusable. I then rebuild these indexes using alter index .. rebuild.
- Other option I have:
alter table mytable move update indexes...
Using 2 I do not have to rebuild indexes because they do not become unusable.
However, I find 2 takes lot longer than one.
My application is down when I do 1 or 2, i.e., no users are using the database...
Can you provide insights why 2 will be so much slower than one ..
- Thanks.