onstat -g xqp query_id

In XPS 8.50, this command displays the optimizer plan for the specified query. If the FROM clause of the SELECT statement declares aliases for one or more tables, output from Version 8.50 of this command displays the aliases. For example, suppose that output from the onstat -g xmp command shows that the identifier of the following query is 123:

select count(*) from orders a, items b where a.order_num=b.order_num

Then the following command displays the corresponding query plan:

onstat -g xqp 123

The following example of output from Version 8.50 displays only the table aliases:

     XMP Query Plan
     
       oper       segid  brid   width  misc info
       -----------------------------------------
       scan       3      0      1      a
       scan       4      0      1      b
       hjoin      2      0      2
       group      2      0      2
       group      1      0      1

A new feature in XPS 8.51 also displays the SQL identifiers of the tables after their aliases, using the following format for the same query:

     XMP Query Plan
     
       oper       segid  brid   width  misc info
       -----------------------------------------
       scan       3      0      1      a  (orders)
       scan       4      0      1      b  (items)
       hjoin      2      0      2
       group      2      0      2
       group      1      0      1

For more information about command-line options of the onstat utility, see Appendix A. Syntax Summaries of Selected Utilities.