ON TABLE HOLD AS &EXECHLDFILE FORMAT FOCUS INDEX SUPHG_EMP_ID
this query is performing differently in two different server, one takes 4 minute to execute and the other takes 11 minute, what could be the reason?This message has been edited. Last edited by: Kerry,
EXCEL, HTML, PDF and OLAP
Is your input file sorted by Employee Id (your index field) on one server, and sorted by something else, on the other server?
What are the two servers running on ?
Memory available, other processes, version of software, etc.
|Powered by Social Strata|