Enhanced support for parallel queries and the ability to choose subquery predicate processing behavior enable experienced DBAs to tune query performance.
