Skip to main content

Nested Loop

Short Description

For each row in the outer table, Nested Loop will scan the inner table for matches. This can lead to poor performance.

Detailed Description

For each row in the outer table, Nested Loop will scan the inner table for matches. This can lead to poor performance as scanning a large inner table can impose a huge I/O load on the server. Targeting indexed columns on the inner table can speed things up by reducing the I/O load.

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