IMPDP with option SKIP_UNUSABLE_INDEXES=YES
Hi All,
I am having one query regarding the Unique indexes.
Actually I Have to migrate the data from one database to another. so for that I am using expdp/impdp utility.
Even in impdp to make it faster I am making all the indexes unusable of all the tables which are indulged in migration activity.
After making all the indexes unusable when I has started the import using IMPDP script with option SKIP_UNUSABLE_INDEXES=YES.
its firstly making all the indexes Valid so what the benefit of this approach.
if instead of making these unusable I am droping these indexes import running faster.