The only very slight issue is one of space. If you create an index without parallelisation, it might take up one extent.Originally posted by prince_jr
I did use paralled option when creating index and was very fast. It created within 5 minutes.
Is there any issues if I use parallel option.
Thank you for all your help
If you had created it with parallel 4, it would take up 4 extents, as each query slave will be allocated an extent.