performance of stored procedure

#1

Hi Friends,

What is the way of tunning the stored procedures ? 'set showplan'
shows the plan of single query only , is there any DBCC command for
this purpose.
kindly let me know .

Thanks

#2

suraj kumar wrote:

Quote:

Hi Friends,

What is the way of tunning the stored procedures ? 'set showplan'
shows the plan of single query only , is there any DBCC command for
this purpose.
kindly let me know .

Thanks
If you run the set showplan on before execution, you should get the full

showplan of the stored proc.

Post the example if your still having problems.

Cheers,
Jason

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

performance of stored procedure

comp.databases.sybase comp.databases.sybase

performance of stored procedure - 07-07-2003 , 01:21 AM

Re: performance of stored procedure - 07-07-2003 , 05:52 AM