Hi,
I'm using derby10.0.2.1 and I have set the following to enable the
timing statistics.
CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
CALL SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1);
I was expecting to see the Optimize, Compile, Execute time in the
derby.log when SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1) is set to 1, as
shown in the example..
Statement Name:
null
Statement Text:
select * from countries
Parse Time: 20
Bind Time: 10
Optimize Time: 50
Generate Time: 20
Compile Time: 100
Execute Time: 10
Begin Compilation Timestamp : 2004-05-25 09:16:21.24
End Compilation Timestamp : 2004-05-25 09:16:21.34
Begin Execution Timestamp : 2004-05-25 09:16:21.35
End Execution Timestamp : 2004-05-25 09:16:21.4
Statement Execution Plan Text:
Table Scan ResultSet for COUNTRIES at read committed isolation
..
..
Instead, I only see the plan
SELECT 'com.sun.portal.community.mc.impl.jdo.pc.CommunityDp' AS
JPOXMETADATA,THIS.COMMUNITY_COMMUNITY_NAMEMR,THIS.LAST_MODIFIED,THIS.ROLE_NAME
FROM COMMUNITYDP THIS, communityuser where communityuser.USER_NAME =
'uid=test,ou=people,o=communitysample,dc=red,dc=iplanet,dc=com' AND
communityuser.community_community_namemr =
this.community_community_namemr and communityuser.role_name =
this.role_name ******* Project-Restrict ResultSet (6):
Number of opens = 1
Rows seen = 20
Rows filtered = 0
restriction = false
projection = true
constructor time (milliseconds) = 0
open time (milliseconds) = 1
next time (milliseconds) = 5
close time (milliseconds) = 0
restriction time (milliseconds) = 0
projection time (milliseconds) = 0
optimizer estimated row count: 18.00
optimizer estimated cost: 738.65
Source result set:
Nested Loop Exists Join ResultSet:
Number of opens = 1
Rows seen from the left = 20
Rows seen from the right = 20
Rows filtered = 0
Rows returned = 20
constructor time (milliseconds) = 0
open time (milliseconds) = 1
What setting am I missing..
Maneesha
