Here is a query that joins two tables: the customer table and the order table.
SELECT Customer_name, Order_number
FROM Customer, order
WHERE Customer_region = ‘EAST’ ;
Your job as DBA is to tune this query to ensure that the proper driving table is used for the rule-based optimizer.
Here are the table statistics that you have gathered:
- There are 100,000 rows in the order table.
- There are 500,000 rows in the customer table.
- There are 50,000 customers in the EAST region.
- There are 20,000 order rows for customers in the EAST region.