When you issue the SET EXPLAIN ON statement, the plan that the optimizer chooses for each subsequent query is written to the sqexplain.out file by default.
If the output file does not exist when you issue SET EXPLAIN ON, the database server creates the output file. If the output file already exists when you issue the SET EXPLAIN ON statement, subsequent output is appended to the file.
If the client application and the database server are on the same computer, the sqexplain.out file is stored in your current directory. If you are using a Version 5.x or earlier client application and the sqexplain.out file does not appear in the current directory, check your home directory for the file. When the current database is on another computer, the sqexplain.out file is stored in your home directory on the remote host.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]