SQL Server : Query Cost (relative to the batch): 100%
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Hello All, Whenever I run any simple select query, it shows me following message in Execution Plan. I have created relevant indexes on the table. Query Cost (relative to the batch): 100% Can anyone tell how can I reduce this Query Cost ? Thanks
You are misunderstanding what Query Cost is. If you run any single query, the cost will always be 100%. If you run multiple queries, the total cost of all of the queries in the batch added together will equal 100%. The value is used to compare the relative cost of each query in the batch as the message says.