stored procedured takes too long to run 1

[shaminda]

The following stored procedure takes too long to run. How can I rewrite this procedure so it will run faster? Sometimes it times out too.

CREATE PROCEDURE [spGetQtyOrderedAS400WorkOrder]
@fdShortNumber varchar(15)
AS
Select sum(WAUORG) as TotalOrdered, sum(WASOQS) as TotalShipped
From F4801
Where WASRST < '95' AND WAITM = @fdShortNumber
GO

 

[SQLDenis]

First thing first, hit CTRL +K and run it again from query analyzer
do you see any table scans?

also why this
Where WASRST < '95'
instead of
Where WASRST < 95 you might be getting a conversion which will result in an index scan instead of an index seek

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[shaminda]

WASRST is a char field

 

[SQLDenis]

and what is the datatype for WAITM ?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/