One of our developer is running a procedure ( which does a select and updates and inserts based on certain criteria). The insert is happening for every 10,000 records.Total records inserted will be 100000 in production which is taking 6 hrs.
the same procedure takes 3 hrs in development. This development environment is refreshed with the copy of production with the daily hotbackup.
In development it runs faster when compared to prod?? any ideas.