SQLServerCentral » Latest topics
Query taking long time
Hi,
The below query is taking around 1000 Seconds.
SELECT ar.MOVE_QTY,ar.DM12,ar.AL_OR,ar.OR_CODE,ar.CAI_CODE,ar.CAI_DESCRIPTION,ar.CST_CODE,ar.AL_NO AL_NO,ar.OPEN_QTY,ar.WH_CODE,ar.ETA_DATE,
ar.CATEGORY,ar.AL_DATE,ar.OD_CODE,
ar.SHIP
The below query is taking around 1000 Seconds.
SELECT ar.MOVE_QTY,ar.DM12,ar.AL_OR,ar.OR_CODE,ar.CAI_CODE,ar.CAI_DESCRIPTION,ar.CST_CODE,ar.AL_NO AL_NO,ar.OPEN_QTY,ar.WH_CODE,ar.ETA_DATE,
ar.CATEGORY,ar.AL_DATE,ar.OD_CODE,
ar.SHIP
No comments:
Post a Comment