I got a subquery that is used more than once in a query. If I use the WITH clause for the subquery, does it help reduce the query time or does impala have inherent optimization where the subquery is only executed once and then reused everywhere it is used irrespective of the WITH clause? Please help clarify.
Thanks!
