Education
Abstract
Are database indices allowed on column oriented storage?
Content
Database indices are supported. At a glance it doesn't seems to be sensible option for column oriented storage but actually all JOINs will internally benefit on performance from its existence. It's recommended to create indices for all columns you're joining by.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHRBY","label":"IBM Integrated Analytics System"},"Component":"","Platform":[{"code":"PF004","label":"Appliance"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
ibm10734963