Run the sp and check the response time of that sp.If it takes a long time

How do you measure the performance of a stored procedure?

Question Posted / jayagopal p.s

Answer Posted / jayagopal p.s

Run the sp and check the response time of that sp.If it
takes a long time to response then optimize the query to
reduce the time usage.

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Detail about query optimizer?

1108

What is a cursor, index in sql?

1072

What is primary key, unique key, and foreign key?

976

What is 1nf 2nf?

1009

What is sql collation?

1212

How is a full-text index updated?

954

What are the disadvantages of indexes?

1090

What is dirty read?

1081

What are the differences between left join and inner join in sql server?

1108

How each E-R model constructs can be mapped to the relational model?

1003

What is the difference function and stored procedure?

1061

What is 'Join' and explain its various types.

1138

What is ddl command?

984

What is row_number function?

1012

How can windows applications connect to sql servers via odbc?

1128