New set options

forceplan

Forces the optimizer to perform joins in the order in which tables are named in the from clause of a query.

prefetch

Disables or enables large I/O (data prefetch) for a session.

statistics subquerycache

Prints statistics about the use of the subquery cache during the execution of a subquery.

table count integer

Specifies the number of tables that are to be optimized at the same time in a join query.