Skip to main content

Nested Loops

Short Description

The Nested Loops operator carries out inner joins, left outer joins, left semi joins and left semi anti joins

Detailed Description

The Nested Loops operator carries out inner joins, left outer joins, left semi joins and left semi anti joins. For each row on the pouter table, a scan is performed on the inner table preferably on an indexed column. Slow nested loops can be caused by a missing index on the join column.

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.

DBmarlin Trial