Press the buttons in descending order in the top right panel.
This second performance test, we are testing the speed of similar select statements without any filters (WHERE clauses). The results will be all customer numbers. Each statement is run 1000 times. You can compare and graph the results.
The graph in the lower right should have two bars, one for the relational performance and a second for the XML performance. Using DB2 9.1, the performance should be similar. However, using DB2 9.5 the XQuery performance may be considerably faster. This is because of improvements made to PureXML in DB2 9.5 that allow it to out perform standard SQL queries under certain circumstances.