After index creation infocube is very slow! (don't produce result)

[former_member250688]

Hello all,

I have the following problem, on a single cube ZWLPIANIF, after the index creation from manage of cube, the query on this cube is totally unusable because during a lot of time (it's necessary stop the execution) I whait over 30 minutes. When I delete the index the query work fine a little bit slow compared to another cube that have index.

ZWLPIANIF have 1,200,000 record loaded in FULL

from RSPC we made the following step:

deletion index

loading

creation index, the job of creation is completed successfully (in SM21 no log, in ST22 no dump, in SM37 is ok).

This is the details of our system SAP NetWeaver 2004s:

SAP_ABA 700 0016 SAPKA70016

SAP_BASIS 700 0016 SAPKB70016

ST-PI 2008_1_700 0000 -

PI_BASIS 2006_1_700 0006 SAPKIPYM06

SAP_BW 700 0018 SAPKW70018

FINBASIS 600 0013 SAPK-60013INFINBASIS

SEM-BW 600 0013 SAPKGS6013

BI_CONT 703 0011 SAPKIBIIQ1

ST-A/PI 01L_BCO700 0000 -

everyone have some ideas?

REGARDS

Gianvito

[Former Member · Accepted solution]

Have you analyze the Query after creation index.

Also check Field Sequence as used in create index

[former_member250688 · Accepted solution]

Where I can do this?

[Former Member · Accepted solution]

Hi,

You can analyse/debug the query through RSRT in execute+debug mode and please check wether the database optimiser chooses the right index that means wether statistics are updated or not.

You can do a reorganise of indexes as well.

Thank you,

Tilak