The scripts in the store procedure run slowly, but quickly exec in the Query Analyzer

[zhenyuandeng]

Hi,

When i call the procedure sp_jysczld_new from the Query Analyzer, it runs slowly.
But when i extract the sql scripts from the procedure sp_jysczld_new, it runs quickly.
Why? I don't understand.

store procedure sp_jysczld_new:
--------------------------------------------------
SET QUOTED_IDENTIFI ER OFF
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE sp_jysczld_new
@gs_userid CHAR(16),
@location char(10),
@pri char (10)
AS

SELECT Z.ORDER_NUM,ZI. ORDER_ITEM,Z.CU STOM_ID,ZI.PROD UCT_ID,ZI.PRODU CT_NAME,ZI.LENG TH,ZI.CDGC,ZI.H EIGHT,ZI.L_HEIG HT,ZI.U_HEIGHT, ZI.CATEGORY,ZI. COLOR_ID,ZI.SGQ TYS,ZI.plannum, ZI.totalwgt,
ZI.banglong,ZI. bangzs,ZI.qgzs ,ZI.BANG_GRADE, ZI.PRI, ZI.LOCATION,Z.E ND_DATE, ZI.NOTESZ AS NOTES--,ZI.MJCOUNT

INTO #Z

FROM ORDERZ Z INNER JOIN ORD_ITEMZ ZI ON Z.ORDER_ID=ZI.O RDER_ID

WHERE (ZI.over_work in ( 'A','B','D') ) AND ZI.PC_MODE = 'Y' and ZI.sgqtys > 0
AND (ZI.location = @location or @location = 'ALL')
AND (ZI.pri = @pri or @pri = 'ALL')
AND Z.order_num in ( select order_num from temp_order_id where username = @gs_userid)


drop table #Z


GO
SET QUOTED_IDENTIFI ER OFF
GO
SET ANSI_NULLS ON
GO
------------------------------------------------------

The scripts which i extract from the store procedure(the same as the store procedure):
---------------------------------------------------

declare @gs_userid char(16)
declare @location char(10)
declare @pri char(10)

set @gs_userid = 'mmm'
set @location = 'ALL'
set @pri = 'ALL'

SELECT Z.ORDER_NUM,ZI. ORDER_ITEM,Z.CU STOM_ID,ZI.PROD UCT_ID,ZI.PRODU CT_NAME,ZI.LENG TH,ZI.CDGC,ZI.H EIGHT,ZI.L_HEIG HT,ZI.U_HEIGHT, ZI.CATEGORY,ZI. COLOR_ID,ZI.SGQ TYS,ZI.plannum, ZI.totalwgt, ZI.banglong,ZI. bangzs,ZI.qgzs ,ZI.BANG_GRADE, ZI.PRI, ZI.LOCATION,Z.E ND_DATE, ZI.NOTESZ AS NOTES--,ZI.MJCOUNT

INTO #Z

FROM ORDERZ Z INNER JOIN ORD_ITEMZ ZI ON Z.ORDER_ID=ZI.O RDER_ID

WHERE (ZI.over_work in ( 'A','B','D') ) AND ZI.PC_MODE = 'Y' and ZI.sgqtys > 0
AND (ZI.location = @location or @location = 'ALL')
AND (ZI.pri = @pri or @pri = 'ALL')
AND Z.order_num in ( select order_num from temp_order_id where username = @gs_userid)
drop table #z

---------------------------------------------------