AnsweredAssumed Answered

Pagesize vs Level for sorted indexes

Question asked by KwintenB on May 10, 2013
Latest reply on Jun 4, 2013 by Dick.Weiland
Historically all our sorted indexes were calculated to fit in a level 3 index with a pagesize of 8904. But with the current data growth we need to recalculate the indexes for better performance, the admin guide points out that it’s best to use indexes of level 3 or 4.
If the index doesn’t ‘fit’ in our standard level 3 pagesize 8904 is it better to raise the level or to raise pagesize.
So my question comes down to this: Is it better to have an index of level 3 with a pagesize of 27992 or an index of level 4 with a pagesize of 8904?

Regards,
Kwinten

Outcomes