The EXPLAIN_SQL Routine

The Data Studio Administration Edition can use the EXPLAIN_SQL routine to obtain a query plan in XML format, interpret the XML, and render the plan visually.

Data Studio consists of a set of tools to use for administration, data modeling, and building queries from data that comes from data servers. The EXPLAIN_SQL routine prepares a query and returns a query plan in XML.

If you plan to use Data Studio to obtain Visual Explain output, you must create and specify a default sbspace name for the SBSPACENAME configuration parameter in your ONCONFIG file. The EXPLAIN_SQL routine creates BLOB objects in this sbspace.

For information on using Data Studio, see the Data Studio documentation.