A derived table always waits until its source table is calculated. Then it replicates the final result of the source table.
Although, two (or more) tables derived from the same source table will be executed in parallel.
A derived table always waits until its source table is calculated. Then it replicates the final result of the source table.
Although, two (or more) tables derived from the same source table will be executed in parallel.