String PreparedStatement.getPlanTree() throws ULjException

The String representation of the plan, represented as a tree.

This method is intended for use during development.

This plan contains the same information as is presented by the getPlan method. The difference is in the presentation.

An empty string is returned if there is no plan. Plans exist when the prepared statement is a SQL query.

The plan shows the operations used to execute the query when the plan is obtained before the associated query has been executed. Additionally, the plan shows the number of rows that each operation produced when the plan is obtained after the query has been executed. This plan can be used to gain insight about the execution of the query.

The following is an example of a plan tree, expressed as a String. It is displayed on multiple lines with '|' characters to represent the structure.

SELECT * FROM tab1, tab2 WHERE col1 > pk2
row: 2 20 10 banana
row: 3 30 10 banana
row: 4 40 10 banana
row: 4 40 30 peach
row: 5 50 10 banana
row: 5 50 30 peach
row: 5 50 40 apple
plan:
 root:7
 |
 inner-join:7
 | |
 | index-scan:7[tab2,prime_key]
 |
 table-scan:5[tab1,prime_key]

• PreparedStatement.getPlan method [UltraLiteJ]