Types of Directives: Join Order
ordered - forces table order to follow the from clause
- bfirst_rows (K) - tells the optimizer to choose a plan optimized to return the first K tuples
- all_rows - tells the optimizer to choose a plan optimized to all tuples