Subquery unnesting is an optimization technique used by SQL query planners to transform subqueries into more efficient join operations, improving query performance by reducing the need for nested loops. This transformation is particularly beneficial in dealing with correlated subqueries, where it can significantly decrease execution time by avoiding repeated execution of the subquery.