2556882 - Why a new column showed up as 1 NBit FP even though IQ UNIQUE(255) was used during table creation ? -- SAP IQ

Symptom

Why a new column showed up as 1 NBit FP even though IQ UNIQUE(255) was used during table creation ?
How to specify the number of bits in an FP index with IQ UNIQUE clause while creating new table ?
Can I avoid nBit conversion by specifying IQ UNIQUE( value ) during creation where value is known number of unique values ?

Environment

IQ 16

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

IQ UNIQUE , FP_NBIT_AUTOSIZE_LIMIT , cardinality , Nbit , FP , Flat , KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.