2457413 - Default index FP displayed as HG type - SAP IQ

Index name refers to FP but index type is displayed as HG when executing sp_iqindex or querying sys.sysindex system table.

Example:

select T.table_name, T.table_id, I.index_name, I.index_type from SYS.SYSINDEX I, SYS.SYSTAB T

 where T.table_id=I.table_id and I.index_name='ASIQ_IDX_T5865_C55_FP' ;

Table_name, Table_id, index_name, index_type

'MyTab',6580,'ASIQ_IDX_T5865_C55_FP','HG'

SAP IQ

 index, HG, FP index name, index type. , KBA , BC-SYB-IQ , Sybase IQ , Problem