I have job that moves data from DB2 to Sybase (4mil records),using Informatica ETL . On Dev box it takes 23 min (drop indexes, load, create indexes).
On Prod box it takes around 2-3 hours. DBAs are saying because of SRDF disks prod will always be slower , but why performance is SOO much different? Table has ~ 10 columns and 2indexes , that are recreated during job run . Creating indexes takes ~ from 20 to 50 min on Prod box . Why ?
Appreciate your help