I usually have SQuirreL SQL for connecting the db, but I don't know how to retrieve the execution plan.
I went through the documentation for Derby and finally got the answer. I still will have to find out how to interpret the stuff !
CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
select * from EDW_BPM_OBJECT;
call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(0);
VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
No comments:
Post a Comment