Interested to Buy Any Domain ? << Click Here >> for more details...
What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning
- 3 Answers
- 9913 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / parmanand
Agree with John, Just to add this is a way to make our query
fast and to reduce the over load on server.
The RECOMPILE option
SET NOCOUNT ON/OFF
Creating Indexes on tables are few points to fine tune our
query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is inline table-value user-defined function?
What is a database table?
Can you use order by when defining a view?
What is create statement?
What is the difference between executequery () and executeupdate ()?
which backup strategy you are following at ur company
What is entity data services?
How exceptions can be handled in sql server programming?
What is delete query?
What languages bi uses to achieve the goal?
What is implicit mode in sql server?
What is postgresql server?
Can two tables have the same primary key?
What are sub reports?
List down some advantages of sql stored procedure?
