Hi I am new to SQL and I have two

[Guest_imported]

Hi I am new to SQL
and I have two stored procedures about 1000 lines each, and When I execute it taking too much time and I want to know /or is there any way that I can Improve the execution time in less time .

thanks
reddy

varra_reddy@hotmail.com

 

[fluteplr]

Probably, but without knowing what and how your stored procedure is operating we really can't help you.

Generic things you can try.

Break the stored procedure down into smaller parts and try to figure out which part is slow.

Run any sql statements that can be separated out from the stored procedure using query analyser and look at the query plan to see what is taking up most of the time.

If you are using cursors try to rewrite the procedure without them.

If you are using temporary tables are you sure you really need them?

 

[Guest_imported]

I am new to SQL!
and I have two stored procedures about 1000 lines each, and it is grabbing information from almost 22 Tables. When I execute it taking too much time and I want to know is there any way that I can Improve the execution in less time. And I am using 6.5 version. In my stored procedure I am using cursors and Temp Tables.

Thanks
REDDY