Set ret_into Option
The set ret_into statement sets the storage structure for tables created by retrieve into statements that do not specify the with structure clause.
For example, this first sequence of statements:
set ret_into hash
retrieve into temp (id = ...)
does the same as this second sequence of statements:
retrieve into temp (id = ...)
modify temp to hash
Both examples create table "temp" as hash. For all table types except heap and cheap, the table is automatically indexed on the first column. (The default storage structure for a table created by the retrieve into statement is cheap.)