3714946 - SAP IQ - How to check the order of columns in multicolumn HG indexes

• Uncertainty regarding the actual order of columns in the HG index for multicolumn primary keys and multicolumn indexes not part of primary keys.
• Confusion caused by the SAP IQ documentation stating: "When the second form is used (PRIMARY KEY followed by a list of columns), the primary key is created including the columns in the order in which they are defined, not the order in which they are listed."
• Questions regarding whether the column_id output from sp_iqpkeys can be relied upon for determining the order of columns in the underlying HG index.
• Inquiry about whether the column_name output from sp_iqindex and sp_iqhelp procedures can be ignored for determining the column order in the HG index.
• Need for clarification on the relationship between the order of columns in the table and the order of columns in the HG index for multicolumn primary keys.
• Request for a method to determine the actual order of columns in multicolumn HG indexes that are not part of a primary key.

• RHEL 8
• SAP IQ 16.1 SP05 PL09

sap iq, hg index, multicolumn primary key, column order, sysidxcol, sp_iqpkeys, sp_iqindex, sp_iqhelp, multicolumn index, primary key, column_id, column_name, iqunload, table constraints, sql reference , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , How To