What is Query optimization in SQL Server ?
Technology
Web App Development
Mobile App Development
Windows App Development
Database Development
UI/UX Development
Cloud Development
SEO
Digital Marketing
Guest Posting
Content Writing
Artificial Intelligence
Data Science
ERP Development
CRM Development
CMS Development
LMS Development
Business Listing
Blockchain Technology
Startup Promotion
AI Tools Integration
Jr software developer trainee
Myself Ashutosh Kumar Verma from Varanasi. I am a Software Developer in MindStick Software pvt. ltd. Prayagraj. I have completed my MCA from VBSP. University, Jaunpur in 2021.
Can you answer this question?
Write Answer1 Answers
Query Optimization in SQL:
Query Optimization is technique in which selects one of the best effective plan from more plans for processing the query. It is the job of the system to select a query evaluation plan which will minimize the cost of query evaluation.
Query optimization means to minimize the cost of query. The cost of a query is depends on many factors. Optimizer is used to optimize the query. Query optimization is process in which to select the optimal way to solve the query. But it is not necessary the select way is perfect because there are many way to solve a query in SQL.