NLJOIN
Short Description
The NLJOIN operator represents a nested loop join
Detailed Description​
The NLJOIN operator represents a nested loop join. A nested loop join scans the inner table for each row selected from the outer one.
Performance is usually better if there is a supporting index on the inner table. Check to confirm the inner table operator is a IXSCAN rather than a TBSCAN to confirm this.
Additional Links​
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.