---
title: "What is Query optimization in SQL Server ?"  
description: "What is Query optimization in SQL Server ?"  
author: "Ashutosh Kumar Verma"  
published: 2021-11-10  
updated: 2021-11-10  
canonical: https://www.mindstick.com/forum/156823/what-is-query-optimization-in-sql-server  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 1 minute  

---

# What is Query optimization in SQL Server ?

What is [Query optimization](https://www.mindstick.com/forum/160279/what-are-the-benefits-of-using-indexed-views-for-query-optimization) in [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) ?

## Replies

### Reply by Steilla Mitchel

**[Query](https://www.mindstick.com/blog/202/sub-query-in-sqlserver) [Optimization](https://yourviews.mindstick.com/view/85459/what-is-conversion-rate-optimization-and-how-to-get-started) in [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database):**

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.

\


---

Original Source: https://www.mindstick.com/forum/156823/what-is-query-optimization-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.