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
How to drop an existing schema in ms sql server?
How do I open a .db file?
How to transfer an existing table from one schema to another schema in ms sql server?
What do you mean by sql server 2005 express management tools?
What is for xml in sql server?
What is model database in sql server?
How do I view a procedure in sql server?
Explain how you can deploy an SSRS report?
What is PROJECTION Operation?
Explain foreign key in sql server?
Do you know what is replace and stuff function in sql server?
In which sql server version report builder introduced?
How to concatenate two binary strings together?
What is the standby server?
What are the rendering extensions of ssrs?
