UDB 8.2性能问题

＃oslevel TBISOLVL :(表格访问隔离级别）未完成阅读输入流： ---- --------- 4）来自运营商＃5 预计行数：2101.97 列：1 子查询谓词ID：不适用列名： --------- --- + Q3.KEY0（A） 5）来自对象APDEV3.EADMPF00 估计行数：1.55354e + 0 7 列数：1 子查询谓词ID：不适用列名： ------------ + Q3.REC 输出流： ------ -------- 6）运营商＃2 预计行数：2101.97 列：2 子查询谓词ID：不适用列名： ---------- - + Q3.KEY0（A）+ Q3.REC 5）IXSCAN :(指数扫描）累计总成本：52.2223 累计CPU成本：3.70197e + 06 累计I / O成本：3.85988 累计重新总成本：2.57454 累计再CPU成本：3.6337e + 06 累计重新I / O成本：0 累积第一行成本：25.7487 估计缓冲池缓冲区：4.85988 参数： ------- - MAXPAGES :(预取的最大页数） 1 PREFETCH :(预取类型）没有 ROWLOCK :(行锁意图）无 SCANDIR :(扫描方向） FORWARD TABLOCK :(表锁意图）无意图谓词： ----- ----- 2）停止密钥谓词关系运算符：小于或等于（< =）需要子查询输入：否过滤系数：0.000451006 谓词文字： -------------- （Q3.KEY0< =：H00001） 3）开始关键谓词关系运算符：小于或等于（< =）子查询输入要求：否过滤系数：0.000451006 谓词文本： -------------- （：H00006< = Q3.KEY0）输入流： ------- ------ 3）来自对象APDEV3.EADMPF00_ASC 预计行数：1.55354e + 07 列数：2 子查询谓词ID：不适用列名： -------- ---- + Q3.KEY0（A）+ Q3。C0FROM (VALUES 0) AS Q1WHERE (:H00006 <= :H00001 SELECTIVITY 1.000000)) AS Q2, APDEV3.EADMPF00 ASQ3WHERE (Q3.KEY0 <= :H00001) AND (:H00006 <= Q3.KEY0)ORDER BY Q3.KEY0 Access Plan:-----------Total Cost: 199.73Query Degree: 1 RowsRETURN( 1)CostI/O|2101.97NLJOIN( 2)199.7315.2282/------+------\1 2101.97TBSCAN FETCH( 3) ( 4)0.000400312 199.7290 15.2282| /---+---\1 2101.97 1.55354e+07TABFNC: SYSIBM IXSCAN TABLE: APDEV3GENROW ( 5) EADMPF0052.22233.85988|1.55354e+07INDEX: APDEV3EADMPF00_ASC 1) RETURN: (Return Result)Cumulative Total Cost: 199.73Cumulative CPU Cost: 5.71287e+06Cumulative I/O Cost: 15.2282Cumulative Re-Total Cost: 3.93082Cumulative Re-CPU Cost: 5.54796e+06Cumulative Re-I/O Cost: 0Cumulative First Row Cost: 38.6057Estimated Bufferpool Buffers: 15.2282 Arguments:---------BLDLEVEL: (Build level)DB2 v8.1.1.80 : s041221STMTHEAP: (Statement heap size)16384 Input Streams:-------------7) From Operator #2 Estimated number of rows: 2101.97Number of columns: 2Subquery predicate ID: Not Applicable Column Names:------------+Q4.KEY0(A)+Q4.REC2) NLJOIN: (Nested Loop Join)Cumulative Total Cost: 199.73Cumulative CPU Cost: 5.71287e+06Cumulative I/O Cost: 15.2282Cumulative Re-Total Cost: 3.93082Cumulative Re-CPU Cost: 5.54796e+06Cumulative Re-I/O Cost: 0Cumulative First Row Cost: 38.6057Estimated Bufferpool Buffers: 15.2282 Arguments:---------EARLYOUT: (Early Out flag)NONEFETCHMAX: (Override for FETCH MAXPAGES)IGNOREISCANMAX: (Override for ISCAN MAXPAGES)IGNORE Input Streams:-------------2) From Operator #3 Estimated number of rows: 1Number of columns: 0Subquery predicate ID: Not Applicable 6) From Operator #4 Estimated number of rows: 2101.97Number of columns: 2Subquery predicate ID: Not Applicable Column Names:------------+Q3.KEY0(A)+Q3.RECOutput Streams:--------------7) To Operator #1 Estimated number of rows: 2101.97Number of columns: 2Subquery predicate ID: Not Applicable Column Names:------------+Q4.KEY0(A)+Q4.REC3) TBSCAN: (Table Scan)Cumulative Total Cost: 0.000400312Cumulative CPU Cost: 565Cumulative I/O Cost: 0Cumulative Re-Total Cost: 0.000400312Cumulative Re-CPU Cost: 565Cumulative Re-I/O Cost: 0Cumulative First Row Cost: 0.000400312Estimated Bufferpool Buffers: 0 Arguments:---------JN INPUT: (Join input leg)OUTERMAXPAGES: (Maximum pages for prefetch)ALLPREFETCH: (Type of Prefetch)NONEROWLOCK : (Row Lock intent)NONESCANDIR : (Scan Direction)FORWARDTABLOCK : (Table Lock intent)INTENT NONETBISOLVL: (Table access Isolation Level)UNCOMMITTED READ Predicates:----------4) Residual PredicateRelational Operator: Less Than or Equal (<=)Subquery Input Required: NoFilter Factor: 1 Predicate Text:--------------(:H00006 <= :H00001 SELECTIVITY 1.000000)Input Streams:-------------1) From Object SYSIBM.GENROW Estimated number of rows: 1Number of columns: 1Subquery predicate ID: Not Applicable Column Names:------------+Q1.NUMBOutput Streams:--------------2) To Operator #2 Estimated number of rows: 1Number of columns: 0Subquery predicate ID: Not Applicable4) FETCH : (Fetch)Cumulative Total Cost: 199.729Cumulative CPU Cost: 5.7123e+06Cumulative I/O Cost: 15.2282Cumulative Re-Total Cost: 3.93042Cumulative Re-CPU Cost: 5.5474e+06Cumulative Re-I/O Cost: 0Cumulative First Row Cost: 38.6053Estimated Bufferpool Buffers: 16.2279 Arguments:---------JN INPUT: (Join input leg)INNERMAXPAGES: (Maximum pages for prefetch)1MAXPAGES: (Maximum pages for prefetch)1PREFETCH: (Type of Prefetch)NONEROWLOCK : (Row Lock intent)NONETABLOCK : (Table Lock intent)INTENT NONETBISOLVL: (Table access Isolation Level)UNCOMMITTED READ Input Streams:-------------4) From Operator #5 Estimated number of rows: 2101.97Number of columns: 1Subquery predicate ID: Not Applicable Column Names:------------+Q3.KEY0(A) 5) From Object APDEV3.EADMPF00 Estimated number of rows: 1.55354e+07Number of columns: 1Subquery predicate ID: Not Applicable Column Names:------------+Q3.RECOutput Streams:--------------6) To Operator #2 Estimated number of rows: 2101.97Number of columns: 2Subquery predicate ID: Not Applicable Column Names:------------+Q3.KEY0(A)+Q3.REC5) IXSCAN: (Index Scan)Cumulative Total Cost: 52.2223Cumulative CPU Cost: 3.70197e+06Cumulative I/O Cost: 3.85988Cumulative Re-Total Cost: 2.57454Cumulative Re-CPU Cost: 3.6337e+06Cumulative Re-I/O Cost: 0Cumulative First Row Cost: 25.7487Estimated Bufferpool Buffers: 4.85988 Arguments:---------MAXPAGES: (Maximum pages for prefetch)1PREFETCH: (Type of Prefetch)NONEROWLOCK : (Row Lock intent)NONESCANDIR : (Scan Direction)FORWARDTABLOCK : (Table Lock intent)INTENT NONE Predicates:----------2) Stop Key PredicateRelational Operator: Less Than or Equal (<=)Subquery Input Required: NoFilter Factor: 0.000451006 Predicate Text:--------------(Q3.KEY0 <= :H00001) 3) Start Key PredicateRelational Operator: Less Than or Equal (<=)Subquery Input Required: NoFilter Factor: 0.000451006 Predicate Text:--------------(:H00006 <= Q3.KEY0)Input Streams:-------------3) From Object APDEV3.EADMPF00_ASC Estimated number of rows: 1.55354e+07Number of columns: 2Subquery predicate ID: Not Applicable Column Names:------------+Q3.KEY0(A)+Q3. 这篇关于UDB 8.2性能问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

cost

UDB 8.2性能问题