There are several reasons that we sometimes need to set rollover limit to Flat Syle FP.
1) A specific query which has FP(3) index spends a lot of time in selectivity scanning.
2) Tokenized fp index makes some problems.
Ex) non-fatal internal error, incorrect result, etc..
SAP SYBASE IQ15.2(from ESD2.8), IQ15.4
Optimize FP index, Rollover, Tokenized FP index, Flat FP index, sybase, IQ, flat, fp, core_options67, option, sp_iqrowdensity , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , How To
About this pageThis 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.