Default name and location of the output file on Windows

On Windows, SET EXPLAIN ON writes the plan that the optimizer chooses for each subsequent query to a file in %INFORMIXDIR%\sqexpln.

For explain output files generated by the SET EXPLAIN statement, the default file name is user_name.out, where user_name is the user login.

For explain output files generated by onmode -Y, the default file name is sqexplain.out.session_id.


Copyright© 2018 HCL Technologies Limited