Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the advantages of partitioning?
Explain the properties of a relational table?
Describe and explain about SQL native client?
Can we deploy SSRS reports on our personal website?
What is default constraint in ms sql server?
how can you check the level of fragmentation on a table? : Sql server administration
What is subquery explain with example?
Which are ddl commands?
Do you know what is difference between index seek vs. Index scan?
What are the different types of backups that exist?
What do you understand by coalesce in sql server?
How to link tables in sql server?
what is a schema in sql server 2005? : Sql server database administration
How can you know if the row fetched from cursor is still valid in underlying table?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
