Skip to Content
Former Member
Mar 20, 2017 at 05:10 PM

Sybase IQ Tiered HG Indexes Recommendation

714 Views Last edit Nov 16, 2017 at 01:46 PM 2 rev


we are in the process of upgrading our IQ 15.4 database. We have had some performance gain by simply upgrading and then by rebuilding FP indexes into NBIT.

We have also had substantial gain in migrating HG indexes into TIERED HG Indexes.

We have recently read that SAP does NOT recommend that we tier all HG indexes and I was wondering why such a recommendation?

What are the drawbacks of having HG Tiered index?

Why not tier every HG indexes in the database?