SQL Explain Status is not reported on the server. Activat or Deactivate on a session with the same status has no effect.
If the file already exists, explain output is appended to it. If a file already exists from the SET EXPLAIN statement, that file is not used until dynamic explain is turned off.
The onmode Y command always takes the file name suffix .out. Any other suffix is removed and replaced by .out.
Be careful with the file path. An explain to a file that cannot be created cannot be removed.
As a directory separator, always write '/', even under Windows this works reliably.
|