What is query tuning?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is query tuning?
Rating:
Query tuning is a process of verifying the number of columns or rows returned by a query. It should not exceed more than the number that is necessary for an application. The verification is done to minimize unnecessary use of cursors, temporary tables, and table variables as it results in the slow processing of application.
Rating:
Was this information helpful?
Other articles
- What is data archiving?
- What are the types of capacity planning?
- What is a temporary table?
- Tip for modifying service accounts.
- What is the RESTORE REWINDONLY statement?