Does any have any idea on how to use the USE_HASH hint?
I'm confused on how to put the tables in the proper syntax. For example: I would use this format /*+ USE_HASH (s i) */
on the driving tables, but in this case there is only 2 tables.
select distinct s.server_id
from servrs s, serv_inst i
where s.svr_id = i.svr_id
Questions:
1. what about the case when there are mulitple tables like 5tables with 5 joins, would each table be used in the hint?
2. What is the difference in writing the hint as follows:
You can check EXPLAIN PLAN output to see if hint made any difference. Specifying two tables in USE_HASH means use HASH only when joining those two tables.