Index creation, with compress and nocompress
Hello,
Please consider the following scenario:
1. create an index on a huge table using compress clause
2. check v$session_longops, remaining time is about 26 hours
same operation but with nocompress clause and remaining time is 10 hours.
Is that a normal behavior? Why is this difference?
Thanks
Please consider the following scenario:
1. create an index on a huge table using compress clause
2. check v$session_longops, remaining time is about 26 hours
same operation but with nocompress clause and remaining time is 10 hours.
Is that a normal behavior? Why is this difference?
Thanks
0