Types of Directives: Join Methods
use_nl - forces nested loop join on specified tables
use_merge - forces sort merge join on specified tables
use_hash - forces hash join on specified tables
avoid_nl - avoids nested loop join on specified tables
avoid_merge - avoids sort merge join on specified tables
avoid_hash - avoids hash join on specified tables