The information about query execution plan is not getting captured in sysxplain_* tables in the XPLAIN-only mode . But the statistics are captured perfectly if the queries are executed . I need to get the query execution plan without actually executing it . Please help .
Error shown when I give a query in XPLAIN-only mode is select * from physicsmarks where P_Id = 34567 ; ERROR XCL16: ResultSet not open. Operation 'getMetaData' not permitted. Verify that autocommit is OFF. I tried with autocommit OFF , but still giving same results . The sysxaplain_* tables are empty after this . Please help . -- View this message in context: http://old.nabble.com/Statistics-are-not-capturing-in-XPLAIN--only-mode-tp32687539p32687539.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
