Community
IBM Community Home
AIOps & Management
Business Analytics
Business Automation
Cloud Pak for Data
Data Science
DataOps
Hybrid Data Management
IBM Japan
IBM Z & LinuxONE
Integration
Internet of Things
Power Systems
Public Cloud
Network Automation
Security
Storage
Supply Chain
Watson Apps
WebSphere & DevOps
Log in
Announcements
Blogs
Groups
Discussions
Events
Glossary
Site Content
Libraries
on this day
between these dates
Posted by
Announcements
Blogs
Groups
Discussions
Events
Glossary
Site Content
Libraries
on this day
between these dates
Posted by
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Hybrid Data Management
Topic groups
HDM Global
Data Server Manager
Database Conversion Workbench
Db2 (On Premises and Cloud)
Db2 Analytics Accelerator for z/OS
Db2 Data Management Console
Db2 Early Access Program
Db2 Event Store
Db2 DevOps Experience Sponsor User Program Community
Db2 for z/OS
Db2 Tools for z/OS
Db2 Warehouse (On Premises and Cloud)
IBM Data Virtualization Manager for z/OS
IBM Query Management Facility (QMF)
Informix
Integrated Analytics Systems
Netezza Performance Server
Open Source Offerings
User groups
Events
Upcoming Hybrid Data Management Events
On Demand Webinars
IBM Expert TV
Virtual Community Events
All IBM Community Events
Participate
Post to Forum
Share a Resource
Blogging on the Community
Connect with Hybrid Data Management Users
All IBM Community Users
Resources
IBM Support
IBM Cloud Support
IBM Champions
Demos
Marketplace
Marketplace
IBM Hybrid Data Management Community
Connect with Db2, Informix, open source, and other data experts to gain value from your data, share insights, and solve problems.
Join / Log in
Skip main navigation (Press Enter).
Toggle navigation
Content types
Announcements
Blogs
Groups
Discussions
Events
Glossary
Site Content
Libraries
Date range
on this day
between these dates
Posted by
User Groups
User Group Tag Test
Db2 Analytics Accelerator for z/OS
DB2
Data and AI on IBM Z
Data and AI on IBM Z
View Only
Group Home
Discussion
24
Library
14
Blogs
24
Events
0
Members
318
Back to Blog List
How do organizing keys work in Db2 Analytics Accelerator and how they differ in V5 and V7
By
Ute Baumbach
posted
Fri August 07, 2020 05:46 AM
Options Dropdown
Mark as Inappropriate
0
Recommend
An organizing key can have an impact on the query response time. When choosing an organizing key, you specify columns of an accelerator-shadow table or accelerator-archive table for the clustering of the table records. This creates grouped segments or blocks of rows with equal or nearby values in the columns selected as organizing keys. If an incoming SQL query references one of the organizing key columns in a range or an equality predicate, the query can run much faster because entire blocks can be skipped during the table scan if the underlying database system can determine that none of the records in a block satisfy the predicate.
The concept of an organizing key has existed in Db2 Analytics Accelerator for many years. It exists in the previous accelerator generation (which is Db2 Analytics Accelerator V5 and earlier versions) and in the current accelerator generation (which is Db2 Analytics Accelerator V7).
However, the feature has been implemented differently in either version. The implementation differences make it necessary to also handle organizing keys in a different way, depending on your product version.
The following white paper describes the implementation differences in the previous and current accelerator generation and describes best practices for defining, changing and maintaining organizing keys on accelerator-shadow tables and accelerator-archive tables:
How do organizing keys work in Db2 Analytics Accelerator and how they differ in V5 and V7
The white paper is useful for Accelerator users who are already familiar with organizing keys in product version 5, and want to continue to use them in version 7. It is also useful for Accelerator users who want to start using organizing keys in either product.
0 comments
7 views
×
Reason for Moderation
Describe the reason this content should be moderated (required)
Permalink
Hybrid Data Management
Topic groups
HDM Global
Data Server Manager
Database Conversion Workbench
Db2 (On Premises and Cloud)
Db2 Analytics Accelerator for z/OS
Db2 Data Management Console
Db2 Early Access Program
Db2 Event Store
Db2 DevOps Experience Sponsor User Program Community
Db2 for z/OS
Db2 Tools for z/OS
Db2 Warehouse (On Premises and Cloud)
IBM Data Virtualization Manager for z/OS
IBM Query Management Facility (QMF)
Informix
Integrated Analytics Systems
Netezza Performance Server
Open Source Offerings
User groups
Events
Upcoming Hybrid Data Management Events
On Demand Webinars
IBM Expert TV
Virtual Community Events
All IBM Community Events
Participate
Post to Forum
Share a Resource
Blogging on the Community
Connect with Hybrid Data Management Users
All IBM Community Users
Resources
IBM Support
IBM Cloud Support
IBM Champions
Demos
Marketplace
Marketplace
Copyright © 2020 IBM Data Science Community. All rights reserved.
Powered by Higher Logic