SQL Server Performance Tuning – Advanced query tuning with joins

By Santhosh N

This explains the advanced query tuning concepts of the SQL Server in terms of using joins

Microsoft SQL Server uses three types of join operations with the query plan it employs which performs sort, union, intersect and difference operations using in-memory sorting and hash join technology, which helps in vertical table partitioning (also called as columnar storage):


1) Hash joins – which allows reductions of the use of denormalization (which is used to achieve better performance by reducing join operations).


2) Nested Loops joins – which requires least I/O and fewer comparisons.


3) Merge joins – when we have sorted indexes, it will fare better.

Related FAQs

This explains the advanced query tuning concepts of the SQL Server in terms of using joins
This explains the QUERY_GOVERNOR_COST_LIMIT option for controlling long running queries in the SQL Server.
This explains where to have a loop if at all required to have one to get the desired result from the database.
This explains how to approach and check for bottlenecks in the SQL queries.
This explains the various precautions needs to be taken care while indexing and choosing what columns needs to be indexed for better performance.
This explains about using functions with Indexed columns in Sql query
SQL Server Performance Tuning – Advanced query tuning with joins  (1701 Views)