Hi,

Creating an index on one of my large tables takes me arounf 2 Hours.

If i create the index using Parallel 8 which will of course reduce the index creation time, and then later on once the index has been created , say i reset it back to NOPARALLEL, will there be any problem in data fetch later on. i mean any unforseen problem in future ? for ex, the standard queries might not use the index etc. etc. ?

is it safe ? because i will be doing it on the Production database.

Thanks