Hi, Do you mean, how to get the information without having to change the SQL statements (without adding "explain analyze")? You can't.
Regards, Thomas On Friday, May 8, 2015, Kriss Lu <[email protected]> wrote: > I am tracing the performance of a program with "explain analyze" command. > I run this command in H2 console, and itt does give many useful > information like that: > > EXPLAIN ANALYZE SELECT * FROM TEST; > SELECT > TEST.ID, > TEST.NAME > FROM PUBLIC.TEST > /* PUBLIC.TEST.tableScan */ > /* scanCount: 1000 */ > /* > total: 85 > TEST.TEST_DATA read: 85 (100%) > */ > > > But how to fetch the output in a running program? I operation the H2 with > JDBC. > > Thanks in advance. > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
