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

SAP Knowledge Base Article - Preview

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 ?


Read more...

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 ONE Support launchpad (Login required).

Search for additional results

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