In Strategy 10.x, it is possible to use derived tables as the intermediate table type, as shown in the image below:
A derived table is nothing but a nested `select` statement. It is a virtual table that's calculated on the fly from a select statement. The biggest benefit of using derived tables over using temporary tables is that they require fewer steps, and everything happens in memory instead of a combination of memory and disk. Since no tables are created on the database side, all the processing is performed on the database server's memory. Therefore, using a derived table does not affect performance on the Strategy side, however, it could potentially hurt performance on the database side depending on the complexity of the query.
It is advisable to contact the database administrator to determine if and how much will performance in the database side be affected by the use of derived tables.
