Vlad Horsun wrote:

>
> AFAIU the key differences from standarts
> CREATED LOCAL TEMPORARY TABLE + INSERT INTO is
>
> 1) the creation moment, which for "transient data set" is DML
> 2) ability to use it in PSQL
>

The difference is that a local temporary table is a defined part of the
SQL standard that applies to SQL Modules. We don't implement SQL
modules. Certainly transient data sets fill the role we had called
local temporary tables - that's the intention - but a goal of the
proposal was to avoid redefining standard syntax.

>
> Transient data set can't be indexed, therefore joins with it can
> be slow.

Of course it can. The two DDL operations are DROP and CREATE INDEX.


Regards,


Ann