using parallel in Index creation
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