# `IndexJoin` and `IndexHashJoin` Processes - Cont'd

__*Is the diagram correct?*__

+ To enhance efficiency, the driving table `employees` is divided into multiple parts. 
+ Each part is scanned and indexed by separate threads, enabling a parallel `IndexJoin/IndexHashJoin` approach.

![`smart`](IndexJoin03_aa_002_20230913.png)

------------------------------------------------------------------------------
To enhance efficiency, the driving table `employees` is divided into multiple parts. Each part is scanned and indexed by separate threads, enabling a parallel `IndexJoin/IndexHashJoin` approach.

While `IndexJoin/IndexHashJoin` matches rows between the driving and driven tables sequentially, this method can introduce network latency in distributed databases, which is less of a concern in traditional monolithic databases. Thus, evaluating the impact of network latency is essential. Next, let's examine the execution plan.