Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
SET EXPLAIN statementUse the SET EXPLAIN statement to enable or disable the recording measurements of queries in the current session, including the plan of the query optimizer, an estimate of the number of rows returned, and the relative cost of the query.
Using the FILE TO option

Using the FILE TO option

When you execute a SET EXPLAIN FILE TO statement, explain output is turned on. The SET EXPLAIN FILE TO statement can change the default file name for the explain output until the end of the session or until another SET EXPLAIN statement is issued.

The filename can be any valid combination of path and file name. If no path component is specified, the file is placed in the default explain output location. The permissions for the file are owned by the current user.

The output file that you specify in the SET EXPLAIN statement can be a new file or an existing file. If the FILE TO clause specifies an existing file, the new output is appended to that file.