performance of stored procedure
This is a discussion on performance of stored procedure within the Sybase forums, part of the Database Server Software category; --> Hi Friends, What is the way of tunning the stored procedures ? 'set showplan' shows the plan of single ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 03:41 PM
| ||||
| ||||
 Re: performance of stored procedure suraj kumar wrote: > 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      |
Linear Mode
