温馨提示：本站仅提供公开网络链接索引服务，不存储、不篡改任何第三方内容，所有内容版权归原作者所有
AI智能索引来源：http://www.ibm.com/support/pages/node/1116615
点击访问原文链接

Db2 for i Performance Enhancements

进入原网站 导航首页
IBM SupportIBM i Technology UpdatesDb2 for i - Technology UpdatesQSYS2.DUMP_PLAN_CACHE - Searching by QRO hashParallel execution of UPDATE and DELETE (SQL) statementsSQL Query Engine (SQE) - QRO Hash size increaseDatabase tooling improved to return wait insightsDatabase tooling changed to return improved labels and unitsQSYS2.DUMP_PLAN_CACHE - Searching by Independent ASP nameQSYS2.DUMP_PLAN_CACHE - Searching by SQL Statement TextNew QAQQINI control PARALLEL_MIN_TIMESQE - Improved CPU costingSQE - Improved SMP processingBlocked insert supported for tables containing generated columnsQSYS2.CLEAR_PLAN_CACHE procedure is enhancedQSYS2.DUMP_PLAN_CACHE procedure is enhancedQSYS2.DUMP_PLAN_CACHE_PROPERTIES procedure is enhancedQSYS2.DUMP_PLAN_CACHE_TOPN procedure is enhancedIASP vary on performance is improvedImproved code generation for SQL procedures, functions, & triggersImplicit parameter marker conversion on some data-change-table-referencesQSYS2.RESET_TABLE_INDEX_STATISTICS() procedureEnhanced processing of Index AdviceImproved Inlining support for SQL Scalar User Defined Functions (UDFs)Statement deterministic functionsInlining support for User Defined Table Functions (UDTFs)EVI Only Access (EOA)Improved code generation for SQL procedures, functions, & triggersEnhanced index build logic for highly concurrent environmentsSQE - improved performance for Outer Join queriesSQE - Index Merge OrderingQSYS2.DATABASE_MONITOR_INFO viewQAQQINI memory preference by pool nameIndex Statistical Catalogs - enhanced to return more detailQSYS2.CLEAR_PLAN_CACHE procedureQSQPRCED() statement level control of QAQQINI optionsVisual Explain ability to drill into a UDTFIndex 'Creation date' added to Navigator's Schemas & Db2 for i CatalogsAutomated DBE tasks for NavigatorDatabase monitor with condensed host variables captureComprehensive support for 'Keep in Memory'Improved Toolbox JDBC driver support for blocked INSERTsQSYS2.SYSPACKAGESTMTSTAT catalogQSYS2.SYSPROGRAMSTMTSTAT catalogQSYS2.DUMP_PLAN_CACHE_TOPN procedureQSYS2.EXTRACT_STATEMENTS procedureDirectory of worldwide contacts

智能索引记录