Materialise in EXPLAIN plan

Analytics

Materialise in EXPLAIN plan

Hi, when I use DISTINCT in a subquery in SQL, EXPLAIN plan shows that particular subquery is materialized. Can anybody explain what does that mean in terms of spool space.
1 REPLY
Junior Contributor

Re: Materialise in EXPLAIN plan

Well, it's the same as any other spool, the estimated size is shown in the Explain step and it persists until there's a spool n (Last Use) step.