How to tune a stored procedure?

Answer Posted / vimal

Store procedure is a pre compiled code
it is doing single task of several task
it is used to reduce the execution time
if we want to call store procedure just we call its name

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are window functions in sql server?

509


What are the advantages of paper records?

556


What is microsoft sql server?

537


Determine when an index is appropriate?

555


How can we delete a table in sql server?

552






Define left outer join?

579


What are magic tables in sql server?

621


How to create user messages with print statements in ms sql server?

588


What is the difference between an index and a unique index?

544


How to provide values to user defined function parameters?

553


How do you test your database? : sql server database administration

521


What is the tcp/ip port on which sql server runs?

564


After removing a table from database, what other related objects have to be dropped explicitly?

553


What are the different index configurations a table can have?

511


What is PROJECTION Operation?

607