Question

The task of optimizer is to decide which join technique should be used for a particular search query. In a decision support system, Sort Merge Join and Hash Based join are some important join techniques which can be used by the optimizer. Discuss some factors on the basis of which optimizer can decide to use either Sort Merge Join or Hash based Join.

Answer 1

The work of the optimizer is to decide which join technique should be used.

In order to determine it, it has to undergo several processes and operations.

It even requires evaluating the statement that has to be executed and whether the particular join technique would be appropriate or not.