You join a small view A (1,000 rows) with a large view B (1,000,000 rows) from two different JDBC sources. For a NESTED join, which branch should generally be the outer (left) branch for best performance?
- AThe large view B, so its rows drive the iteration
- BThe small view A, so fewer queries are issued to the other source
- CIt does not matter; nested join performance is independent of branch order
- DNeither; nested joins are not allowed across different JDBC sources