DB2 Universal Database Version 9.7, 5622-044 (c) Copyright IBM Corp. 1991, 2009 Licensed Material - Program Property of IBM IBM DATABASE 2 Explain Table Format Tool ******************** EXPLAIN INSTANCE ******************** DB2_VERSION: 09.07.5 SOURCE_NAME: SYSSH200 SOURCE_SCHEMA: NULLID SOURCE_VERSION: EXPLAIN_TIME: 2015-11-05-11.06.42.785081 EXPLAIN_REQUESTER: CAMUNDA Database Context: ---------------- Parallelism: None CPU Speed: 9.446885e-08 Comm Speed: 0 Buffer Pool size: 7423 Sort Heap size: 587 Database Heap size: 2377 Lock List size: 13726 Maximum Lock List: 60 Average Applications: 1 Locks Available: 263539 Package Context: --------------- SQL Type: Dynamic Optimization Level: 5 Blocking: Block All Cursors Isolation Level: Cursor Stability ---------------- STATEMENT 1 SECTION 65 ---------------- QUERYNO: 1 QUERYTAG: Statement Type: Select Updatable: No Deletable: No Query Degree: 1 Original Statement: ------------------ SELECT SUB.* FROM (select RES.*, row_number () over (ORDER BY RES.ID_ asc) rnk FROM (select distinct RES.* from CAMUNDA.ACT_RU_JOB RES where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= current timestamp) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ < current timestamp) and ( RES.SUSPENSION_STATE_ = 1 or RES.SUSPENSION_STATE_ is null) and (RES.DEPLOYMENT_ID_ is null or RES.DEPLOYMENT_ID_ in ('1', '40101'))) RES) SUB WHERE SUB.rnk >= 1 AND SUB.rnk < 5 ORDER BY SUB.rnk Optimized Statement: ------------------- SELECT Q3.ID_ AS "ID_", Q3.REV_ AS "REV_", Q3.TYPE_ AS "TYPE_", Q3.LOCK_EXP_TIME_ AS "LOCK_EXP_TIME_", Q3.LOCK_OWNER_ AS "LOCK_OWNER_", Q3.EXCLUSIVE_ AS "EXCLUSIVE_", Q3.EXECUTION_ID_ AS "EXECUTION_ID_", Q3.PROCESS_INSTANCE_ID_ AS "PROCESS_INSTANCE_ID_", Q3.PROCESS_DEF_ID_ AS "PROCESS_DEF_ID_", Q3.PROCESS_DEF_KEY_ AS "PROCESS_DEF_KEY_", Q3.RETRIES_ AS "RETRIES_", Q3.EXCEPTION_STACK_ID_ AS "EXCEPTION_STACK_ID_", Q3.EXCEPTION_MSG_ AS "EXCEPTION_MSG_", Q3.DUEDATE_ AS "DUEDATE_", Q3.REPEAT_ AS "REPEAT_", Q3.HANDLER_TYPE_ AS "HANDLER_TYPE_", Q3.HANDLER_CFG_ AS "HANDLER_CFG_", Q3.DEPLOYMENT_ID_ AS "DEPLOYMENT_ID_", Q3.SUSPENSION_STATE_ AS "SUSPENSION_STATE_", Q3.JOB_DEF_ID_ AS "JOB_DEF_ID_", Q3.SEQUENCE_COUNTER_ AS "SEQUENCE_COUNTER_", Q3.$C21 AS "RNK" FROM (SELECT Q2.ID_, Q2.REV_, Q2.TYPE_, Q2.LOCK_EXP_TIME_, Q2.LOCK_OWNER_, Q2.EXCLUSIVE_, Q2.EXECUTION_ID_, Q2.PROCESS_INSTANCE_ID_, Q2.PROCESS_DEF_ID_, Q2.PROCESS_DEF_KEY_, Q2.RETRIES_, Q2.EXCEPTION_STACK_ID_, Q2.EXCEPTION_MSG_, Q2.DUEDATE_, Q2.REPEAT_, Q2.HANDLER_TYPE_, Q2.HANDLER_CFG_, Q2.DEPLOYMENT_ID_, Q2.SUSPENSION_STATE_, Q2.JOB_DEF_ID_, Q2.SEQUENCE_COUNTER_, ROW_NUMBER() OVER (ORDER BY Q2.ID_) FROM (SELECT Q1.ID_, Q1.REV_, Q1.TYPE_, Q1.LOCK_EXP_TIME_, Q1.LOCK_OWNER_, Q1.EXCLUSIVE_, Q1.EXECUTION_ID_, Q1.PROCESS_INSTANCE_ID_, Q1.PROCESS_DEF_ID_, Q1.PROCESS_DEF_KEY_, Q1.RETRIES_, Q1.EXCEPTION_STACK_ID_, Q1.EXCEPTION_MSG_, Q1.DUEDATE_, Q1.REPEAT_, Q1.HANDLER_TYPE_, Q1.HANDLER_CFG_, Q1.DEPLOYMENT_ID_, Q1.SUSPENSION_STATE_, Q1.JOB_DEF_ID_, Q1.SEQUENCE_COUNTER_ FROM CAMUNDA.ACT_RU_JOB AS Q1 WHERE (0 < Q1.RETRIES_) AND (Q1.DUEDATE_ IS NULL OR (Q1.DUEDATE_ <= CURRENT TIMESTAMP)) AND (Q1.LOCK_OWNER_ IS NULL OR (Q1.LOCK_EXP_TIME_ < CURRENT TIMESTAMP)) AND ((Q1.SUSPENSION_STATE_ = 1) OR Q1.SUSPENSION_STATE_ IS NULL) AND (Q1.DEPLOYMENT_ID_ IS NULL OR Q1.DEPLOYMENT_ID_ IN ('1', '40101'))) AS Q2) AS Q3 WHERE (Q3.$C21 < 5) AND (1 <= Q3.$C21) ORDER BY Q3.$C21 Access Plan: ----------- Total Cost: 149.595 Query Degree: 1 Rows RETURN ( 1) Cost I/O | 40.571 TBSCAN ( 2) 149.595 141 | 40.571 SORT ( 3) 149.594 141 | 40.571 FILTER ( 4) 149.586 141 | 405.71 TBSCAN ( 5) 149.52 141 | 405.71 SORT ( 6) 149.511 141 | 405.71 TBSCAN ( 7) 149.418 141 | 20000 TABLE: CAMUNDA ACT_RU_JOB Q1 Extended Diagnostic Information: -------------------------------- No extended Diagnostic Information for this statement. Plan Details: ------------- 1) RETURN: (Return Result) Cumulative Total Cost: 149.595 Cumulative CPU Cost: 6.49394e+07 Cumulative I/O Cost: 141 Cumulative Re-Total Cost: 5.94822 Cumulative Re-CPU Cost: 6.29649e+07 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 149.594 Estimated Bufferpool Buffers: 0 Arguments: --------- BLDLEVEL: (Build level) DB2 v9.7.0.5 : special_27924 HEAPUSE : (Maximum Statement Heap Usage) 160 Pages PREPTIME: (Statement prepare time) 9 milliseconds STMTHEAP: (Statement heap size) 8192 Input Streams: ------------- 7) From Operator #2 Estimated number of rows: 40.571 Number of columns: 22 Subquery predicate ID: Not Applicable Column Names: ------------ +Q4.RNK(A)+Q4.SEQUENCE_COUNTER_+Q4.JOB_DEF_ID_ +Q4.SUSPENSION_STATE_+Q4.DEPLOYMENT_ID_ +Q4.HANDLER_CFG_+Q4.HANDLER_TYPE_+Q4.REPEAT_ +Q4.DUEDATE_+Q4.EXCEPTION_MSG_ +Q4.EXCEPTION_STACK_ID_+Q4.RETRIES_ +Q4.PROCESS_DEF_KEY_+Q4.PROCESS_DEF_ID_ +Q4.PROCESS_INSTANCE_ID_+Q4.EXECUTION_ID_ +Q4.EXCLUSIVE_+Q4.LOCK_OWNER_ +Q4.LOCK_EXP_TIME_+Q4.TYPE_+Q4.REV_+Q4.ID_ 2) TBSCAN: (Table Scan) Cumulative Total Cost: 149.595 Cumulative CPU Cost: 6.49394e+07 Cumulative I/O Cost: 141 Cumulative Re-Total Cost: 5.94822 Cumulative Re-CPU Cost: 6.29649e+07 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 149.594 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE SCANDIR : (Scan Direction) FORWARD SPEED : (Assumed speed of scan, in sharing structures) SLOW THROTTLE: (Scan may be throttled, for scan sharing) FALSE VISIBLE : (May be included in scan sharing structures) FALSE WRAPPING: (Scan may start anywhere and wrap) FALSE Input Streams: ------------- 6) From Operator #3 Estimated number of rows: 40.571 Number of columns: 22 Subquery predicate ID: Not Applicable Column Names: ------------ +Q3.RNK(A)+Q3.SEQUENCE_COUNTER_+Q3.JOB_DEF_ID_ +Q3.SUSPENSION_STATE_+Q3.DEPLOYMENT_ID_ +Q3.HANDLER_CFG_+Q3.HANDLER_TYPE_+Q3.REPEAT_ +Q3.DUEDATE_+Q3.EXCEPTION_MSG_ +Q3.EXCEPTION_STACK_ID_+Q3.RETRIES_ +Q3.PROCESS_DEF_KEY_+Q3.PROCESS_DEF_ID_ +Q3.PROCESS_INSTANCE_ID_+Q3.EXECUTION_ID_ +Q3.EXCLUSIVE_+Q3.LOCK_OWNER_ +Q3.LOCK_EXP_TIME_+Q3.TYPE_+Q3.REV_+Q3.ID_ Output Streams: -------------- 7) To Operator #1 Estimated number of rows: 40.571 Number of columns: 22 Subquery predicate ID: Not Applicable Column Names: ------------ +Q4.RNK(A)+Q4.SEQUENCE_COUNTER_+Q4.JOB_DEF_ID_ +Q4.SUSPENSION_STATE_+Q4.DEPLOYMENT_ID_ +Q4.HANDLER_CFG_+Q4.HANDLER_TYPE_+Q4.REPEAT_ +Q4.DUEDATE_+Q4.EXCEPTION_MSG_ +Q4.EXCEPTION_STACK_ID_+Q4.RETRIES_ +Q4.PROCESS_DEF_KEY_+Q4.PROCESS_DEF_ID_ +Q4.PROCESS_INSTANCE_ID_+Q4.EXECUTION_ID_ +Q4.EXCLUSIVE_+Q4.LOCK_OWNER_ +Q4.LOCK_EXP_TIME_+Q4.TYPE_+Q4.REV_+Q4.ID_ 3) SORT : (Sort) Cumulative Total Cost: 149.594 Cumulative CPU Cost: 6.49277e+07 Cumulative I/O Cost: 141 Cumulative Re-Total Cost: 5.94712 Cumulative Re-CPU Cost: 6.29532e+07 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 149.594 Estimated Bufferpool Buffers: 0 Arguments: --------- DUPLWARN: (Duplicates Warning flag) FALSE NUMROWS : (Estimated number of rows) 41 ROWWIDTH: (Estimated width of rows) 228 SORTKEY : (Sort Key column) 1: Q3.RNK(A) TEMPSIZE: (Temporary Table Page Size) 32768 UNIQUE : (Uniqueness required flag) FALSE Input Streams: ------------- 5) From Operator #4 Estimated number of rows: 40.571 Number of columns: 22 Subquery predicate ID: Not Applicable Column Names: ------------ +Q3.ID_(A)+Q3.SEQUENCE_COUNTER_+Q3.JOB_DEF_ID_ +Q3.SUSPENSION_STATE_+Q3.DEPLOYMENT_ID_ +Q3.HANDLER_CFG_+Q3.HANDLER_TYPE_+Q3.REPEAT_ +Q3.DUEDATE_+Q3.EXCEPTION_MSG_ +Q3.EXCEPTION_STACK_ID_+Q3.RETRIES_ +Q3.PROCESS_DEF_KEY_+Q3.PROCESS_DEF_ID_ +Q3.PROCESS_INSTANCE_ID_+Q3.EXECUTION_ID_ +Q3.EXCLUSIVE_+Q3.LOCK_OWNER_ +Q3.LOCK_EXP_TIME_+Q3.TYPE_+Q3.REV_+Q3.RNK Output Streams: -------------- 6) To Operator #2 Estimated number of rows: 40.571 Number of columns: 22 Subquery predicate ID: Not Applicable Column Names: ------------ +Q3.RNK(A)+Q3.SEQUENCE_COUNTER_+Q3.JOB_DEF_ID_ +Q3.SUSPENSION_STATE_+Q3.DEPLOYMENT_ID_ +Q3.HANDLER_CFG_+Q3.HANDLER_TYPE_+Q3.REPEAT_ +Q3.DUEDATE_+Q3.EXCEPTION_MSG_ +Q3.EXCEPTION_STACK_ID_+Q3.RETRIES_ +Q3.PROCESS_DEF_KEY_+Q3.PROCESS_DEF_ID_ +Q3.PROCESS_INSTANCE_ID_+Q3.EXECUTION_ID_ +Q3.EXCLUSIVE_+Q3.LOCK_OWNER_ +Q3.LOCK_EXP_TIME_+Q3.TYPE_+Q3.REV_+Q3.ID_ 4) FILTER: (Filter) Cumulative Total Cost: 149.586 Cumulative CPU Cost: 6.48447e+07 Cumulative I/O Cost: 141 Cumulative Re-Total Cost: 5.94712 Cumulative Re-CPU Cost: 6.29532e+07 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 149.515 Estimated Bufferpool Buffers: 0 Predicates: ---------- 2) Residual Predicate, Comparison Operator: Less Than (<) Subquery Input Required: No Filter Factor: 0.333333 Predicate Text: -------------- (Q3.$C21 < 5) 3) Residual Predicate, Comparison Operator: Less Than or Equal (<=) Subquery Input Required: No Filter Factor: 0.333333 Predicate Text: -------------- (1 <= Q3.$C21) Input Streams: ------------- 4) From Operator #5 Estimated number of rows: 405.71 Number of columns: 22 Subquery predicate ID: Not Applicable Column Names: ------------ +Q3.ID_(A)+Q3.SEQUENCE_COUNTER_+Q3.JOB_DEF_ID_ +Q3.SUSPENSION_STATE_+Q3.DEPLOYMENT_ID_ +Q3.HANDLER_CFG_+Q3.HANDLER_TYPE_+Q3.REPEAT_ +Q3.DUEDATE_+Q3.EXCEPTION_MSG_ +Q3.EXCEPTION_STACK_ID_+Q3.RETRIES_ +Q3.PROCESS_DEF_KEY_+Q3.PROCESS_DEF_ID_ +Q3.PROCESS_INSTANCE_ID_+Q3.EXECUTION_ID_ +Q3.EXCLUSIVE_+Q3.LOCK_OWNER_ +Q3.LOCK_EXP_TIME_+Q3.TYPE_+Q3.REV_+Q3.RNK Output Streams: -------------- 5) To Operator #3 Estimated number of rows: 40.571 Number of columns: 22 Subquery predicate ID: Not Applicable Column Names: ------------ +Q3.ID_(A)+Q3.SEQUENCE_COUNTER_+Q3.JOB_DEF_ID_ +Q3.SUSPENSION_STATE_+Q3.DEPLOYMENT_ID_ +Q3.HANDLER_CFG_+Q3.HANDLER_TYPE_+Q3.REPEAT_ +Q3.DUEDATE_+Q3.EXCEPTION_MSG_ +Q3.EXCEPTION_STACK_ID_+Q3.RETRIES_ +Q3.PROCESS_DEF_KEY_+Q3.PROCESS_DEF_ID_ +Q3.PROCESS_INSTANCE_ID_+Q3.EXECUTION_ID_ +Q3.EXCLUSIVE_+Q3.LOCK_OWNER_ +Q3.LOCK_EXP_TIME_+Q3.TYPE_+Q3.REV_+Q3.RNK 5) TBSCAN: (Table Scan) Cumulative Total Cost: 149.52 Cumulative CPU Cost: 6.41507e+07 Cumulative I/O Cost: 141 Cumulative Re-Total Cost: 5.88155 Cumulative Re-CPU Cost: 6.22592e+07 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 149.511 Estimated Bufferpool Buffers: 0 Arguments: --------- MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) NONE SCANDIR : (Scan Direction) FORWARD SPEED : (Assumed speed of scan, in sharing structures) SLOW THROTTLE: (Scan may be throttled, for scan sharing) FALSE VISIBLE : (May be included in scan sharing structures) FALSE WRAPPING: (Scan may start anywhere and wrap) FALSE Input Streams: ------------- 3) From Operator #6 Estimated number of rows: 405.71 Number of columns: 21 Subquery predicate ID: Not Applicable Column Names: ------------ +Q2.ID_(A)+Q2.SEQUENCE_COUNTER_+Q2.JOB_DEF_ID_ +Q2.SUSPENSION_STATE_+Q2.DEPLOYMENT_ID_ +Q2.HANDLER_CFG_+Q2.HANDLER_TYPE_+Q2.REPEAT_ +Q2.DUEDATE_+Q2.EXCEPTION_MSG_ +Q2.EXCEPTION_STACK_ID_+Q2.RETRIES_ +Q2.PROCESS_DEF_KEY_+Q2.PROCESS_DEF_ID_ +Q2.PROCESS_INSTANCE_ID_+Q2.EXECUTION_ID_ +Q2.EXCLUSIVE_+Q2.LOCK_OWNER_ +Q2.LOCK_EXP_TIME_+Q2.TYPE_+Q2.REV_ Output Streams: -------------- 4) To Operator #4 Estimated number of rows: 405.71 Number of columns: 22 Subquery predicate ID: Not Applicable Column Names: ------------ +Q3.ID_(A)+Q3.SEQUENCE_COUNTER_+Q3.JOB_DEF_ID_ +Q3.SUSPENSION_STATE_+Q3.DEPLOYMENT_ID_ +Q3.HANDLER_CFG_+Q3.HANDLER_TYPE_+Q3.REPEAT_ +Q3.DUEDATE_+Q3.EXCEPTION_MSG_ +Q3.EXCEPTION_STACK_ID_+Q3.RETRIES_ +Q3.PROCESS_DEF_KEY_+Q3.PROCESS_DEF_ID_ +Q3.PROCESS_INSTANCE_ID_+Q3.EXECUTION_ID_ +Q3.EXCLUSIVE_+Q3.LOCK_OWNER_ +Q3.LOCK_EXP_TIME_+Q3.TYPE_+Q3.REV_+Q3.RNK 6) SORT : (Sort) Cumulative Total Cost: 149.511 Cumulative CPU Cost: 6.40477e+07 Cumulative I/O Cost: 141 Cumulative Re-Total Cost: 5.87183 Cumulative Re-CPU Cost: 6.21562e+07 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 149.511 Estimated Bufferpool Buffers: 141 Arguments: --------- DUPLWARN: (Duplicates Warning flag) FALSE NUMROWS : (Estimated number of rows) 406 ROWWIDTH: (Estimated width of rows) 224 SORTKEY : (Sort Key column) 1: Q2.ID_(A) TEMPSIZE: (Temporary Table Page Size) 32768 UNIQUE : (Uniqueness required flag) FALSE Input Streams: ------------- 2) From Operator #7 Estimated number of rows: 405.71 Number of columns: 21 Subquery predicate ID: Not Applicable Column Names: ------------ +Q2.SEQUENCE_COUNTER_+Q2.JOB_DEF_ID_ +Q2.SUSPENSION_STATE_+Q2.DEPLOYMENT_ID_ +Q2.HANDLER_CFG_+Q2.HANDLER_TYPE_+Q2.REPEAT_ +Q2.DUEDATE_+Q2.EXCEPTION_MSG_ +Q2.EXCEPTION_STACK_ID_+Q2.RETRIES_ +Q2.PROCESS_DEF_KEY_+Q2.PROCESS_DEF_ID_ +Q2.PROCESS_INSTANCE_ID_+Q2.EXECUTION_ID_ +Q2.EXCLUSIVE_+Q2.LOCK_OWNER_ +Q2.LOCK_EXP_TIME_+Q2.TYPE_+Q2.REV_+Q2.ID_ Output Streams: -------------- 3) To Operator #5 Estimated number of rows: 405.71 Number of columns: 21 Subquery predicate ID: Not Applicable Column Names: ------------ +Q2.ID_(A)+Q2.SEQUENCE_COUNTER_+Q2.JOB_DEF_ID_ +Q2.SUSPENSION_STATE_+Q2.DEPLOYMENT_ID_ +Q2.HANDLER_CFG_+Q2.HANDLER_TYPE_+Q2.REPEAT_ +Q2.DUEDATE_+Q2.EXCEPTION_MSG_ +Q2.EXCEPTION_STACK_ID_+Q2.RETRIES_ +Q2.PROCESS_DEF_KEY_+Q2.PROCESS_DEF_ID_ +Q2.PROCESS_INSTANCE_ID_+Q2.EXECUTION_ID_ +Q2.EXCLUSIVE_+Q2.LOCK_OWNER_ +Q2.LOCK_EXP_TIME_+Q2.TYPE_+Q2.REV_ 7) TBSCAN: (Table Scan) Cumulative Total Cost: 149.418 Cumulative CPU Cost: 6.30717e+07 Cumulative I/O Cost: 141 Cumulative Re-Total Cost: 5.87183 Cumulative Re-CPU Cost: 6.21562e+07 Cumulative Re-I/O Cost: 0 Cumulative First Row Cost: 7.90762 Estimated Bufferpool Buffers: 141 Arguments: --------- CUR_COMM: (Currently Committed) TRUE LCKAVOID: (Lock Avoidance) TRUE MAXPAGES: (Maximum pages for prefetch) ALL PREFETCH: (Type of Prefetch) SEQUENTIAL ROWLOCK : (Row Lock intent) SHARE (CS/RS) SCANDIR : (Scan Direction) FORWARD SKIP_INS: (Skip Inserted Rows) TRUE SPEED : (Assumed speed of scan, in sharing structures) FAST TABLOCK : (Table Lock intent) INTENT SHARE TBISOLVL: (Table access Isolation Level) CURSOR STABILITY THROTTLE: (Scan may be throttled, for scan sharing) TRUE VISIBLE : (May be included in scan sharing structures) TRUE WRAPPING: (Scan may start anywhere and wrap) TRUE Predicates: ---------- 4) Sargable Predicate, Comparison Operator: Less Than (<) Subquery Input Required: No Filter Factor: 0.333333 Predicate Text: -------------- (0 < Q1.RETRIES_) 5) Sargable Predicate, Comparison Operator: Not Applicable Subquery Input Required: No Filter Factor: 0.0608565 Predicate Text: -------------- (Q1.DUEDATE_ IS NULL OR (Q1.DUEDATE_ <= CURRENT TIMESTAMP)) 8) Sargable Predicate, Comparison Operator: Not Applicable Subquery Input Required: No Filter Factor: 1 Predicate Text: -------------- (Q1.LOCK_OWNER_ IS NULL OR (Q1.LOCK_EXP_TIME_ < CURRENT TIMESTAMP)) 11) Sargable Predicate, Comparison Operator: Not Applicable Subquery Input Required: No Filter Factor: 1 Predicate Text: -------------- ((Q1.SUSPENSION_STATE_ = 1) OR Q1.SUSPENSION_STATE_ IS NULL) 14) Sargable Predicate, Comparison Operator: Not Applicable Subquery Input Required: No Filter Factor: 1 Predicate Text: -------------- (Q1.DEPLOYMENT_ID_ IS NULL OR Q1.DEPLOYMENT_ID_ IN ('1', '40101')) Input Streams: ------------- 1) From Object CAMUNDA.ACT_RU_JOB Estimated number of rows: 20000 Number of columns: 22 Subquery predicate ID: Not Applicable Column Names: ------------ +Q1.$RID$+Q1.SEQUENCE_COUNTER_+Q1.JOB_DEF_ID_ +Q1.HANDLER_CFG_+Q1.HANDLER_TYPE_+Q1.REPEAT_ +Q1.EXCEPTION_MSG_+Q1.EXCEPTION_STACK_ID_ +Q1.PROCESS_DEF_KEY_+Q1.PROCESS_DEF_ID_ +Q1.PROCESS_INSTANCE_ID_+Q1.EXECUTION_ID_ +Q1.EXCLUSIVE_+Q1.TYPE_+Q1.REV_+Q1.ID_ +Q1.DEPLOYMENT_ID_+Q1.SUSPENSION_STATE_ +Q1.LOCK_EXP_TIME_+Q1.LOCK_OWNER_+Q1.DUEDATE_ +Q1.RETRIES_ Output Streams: -------------- 2) To Operator #6 Estimated number of rows: 405.71 Number of columns: 21 Subquery predicate ID: Not Applicable Column Names: ------------ +Q2.SEQUENCE_COUNTER_+Q2.JOB_DEF_ID_ +Q2.SUSPENSION_STATE_+Q2.DEPLOYMENT_ID_ +Q2.HANDLER_CFG_+Q2.HANDLER_TYPE_+Q2.REPEAT_ +Q2.DUEDATE_+Q2.EXCEPTION_MSG_ +Q2.EXCEPTION_STACK_ID_+Q2.RETRIES_ +Q2.PROCESS_DEF_KEY_+Q2.PROCESS_DEF_ID_ +Q2.PROCESS_INSTANCE_ID_+Q2.EXECUTION_ID_ +Q2.EXCLUSIVE_+Q2.LOCK_OWNER_ +Q2.LOCK_EXP_TIME_+Q2.TYPE_+Q2.REV_+Q2.ID_ Objects Used in Access Plan: --------------------------- Schema: CAMUNDA Name: ACT_RU_JOB Type: Table Time of creation: 2015-11-05-10.29.54.501723 Last statistics update: 2015-11-05-10.59.59.930000 Number of columns: 21 Number of rows: 20000 Width of rows: 225 Number of buffer pool pages: 141 Number of data partitions: 1 Distinct row values: No Tablespace name: USERSPACE1 Tablespace overhead: 7.500000 Tablespace transfer rate: 0.060000 Source for statistics: Single Node Prefetch page count: 32 Container extent page count: 32 Table overflow record count: 0 Table Active Blocks: -1 Average Row Compression Ratio: 0 Percentage Rows Compressed: 0 Average Compressed Row Size: 0