my procedure are fast, but only after execute a first time.

CREATE PROC DBO.PNX_16_EXAMES_IDENTIFICADOR

@TT INT=NULL,@D1 DATETIME=NULL,@D2 DATETIME=NULL,@ARG INT=NULL,@CMBC INT=NULL,@CMBI INT=NULL,@REC INT=NULL,

@CKF INT=NULL

AS

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

DECLARE @T TABLE(CNV INT,SCNV VARCHAR(255),ID_PS INT,SID VARCHAR(255),NCT INT,NOME VARCHAR(255),RF1 VARCHAR(50),DAT DATETIME,VLR MONEY,CEX VARCHAR(100),DAB...

tks!

Command(s) completed successfully.