Answer Posted / gopi a
Stored Procedure is Precompiled set of quries. Stored
Procedure performence fully depended on this queries. First
Look the queries performence using Execution Plan. After
find the Queries, just check the Index(for table used in
query) and look the join conditions between tables in the
query. - This is way we need to approch to tune the SP.
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What command do we use to rename a database?
Explain trigger and its types?
What is sql server replication? : sql server replication
What are functions in the sql server?
Create and insert into temp table in sql server?
What are the differences between char and varchar in ms sql server?
Is INSTEAD OF trigger directly applicable to Table ?
What does the not null constraint do?
Explain the concept of view and Types of views in SQL server?
How to change the name of a database user?
How to find out the list schema name and table name for the database?
How to enter comments in transact-sql statements?
What is the command used to recompile the stored procedure at run time?
What is the difference between sdf and mdf?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?