JOIN for query parallelism
JOIN for query hinting
JOIN for query caching
JOIN for query rewriting
JOIN for query optimization