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 can I check that whether automatic statistic update is enabled or not?
Which joins are sql server default?
Determine when to use stored procedure to complete sql server tasks?
What area unit the various kinds of info compression introduced in sql server 2008?
How to return the date part only from a sql server datetime datatype?
How to create a Master database in SQL server ?
How many full-text indexes can a table have?
What are the steps to insert a table?
List some case manipulation functions in sql?
If no size is defined while creating the database, what size will the database have?
What is sql server transaction log file?
can we have a nested transaction? : Sql server database administration
What are the different authentication modes in sql server?
What is RMS migrations?
What is a trigger what are the advantages of trigger?
