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:

does the same as this second sequence of statements:

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.)