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.
Click Here to Expand Forum to Full Width