Subject pump vs restore
Author Gary Benade

I did a data pump to onto a blank database to get the metadata of my live
database the same as the development server. Seemed like a good idea at the
time, but now the live server is generating plans different to the dev
server, even though the data is the same. The system has become unusable
because the queries take so long to run. I suspect it has something to do
with the fact that a pump adds data with the indexes active, while a restore
adds the indexes on complete data thereby creating more accurate stats for
selectivity. Would disabling and then renenabling an index do the same
thing, or maybe dropping and recreating it? The data is very big so I dont
want to do a backup/restore unless I really have to.