Before you run the
Refer to "SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA system procedure" in the
Refer to "SYSXPLAIN_STATEMENTS system table" in the
You can run the tool as follows in the directory where your database is located (all on one line).
The options can be passed according to your requirements. Consider the following possible scenarios:
To generate an XML file of the query plan, specify the following option:
The path can be either absolute or relative. If the root filename does
not have a suffix, the tool appends
To generate a plain HTML file of the query plan, you can use the default
simple style sheet provided with
If the root filename does not have a suffix, the tool appends
To generate the XML file as well, specify the following options:
To use a different style sheet that does not contain any Javascript functions, specify the following options:
To generate the XML file as well, specify the following options:
To generate an advanced view of the query plan, you can use advanced XSL
style sheets provided with