HOW TO DELETE INDEXES IN SE37

[Former Member]

Hi all

This is Sudhakar

can any one help me out How to delete the indexes in SE37

Please tell me the steps

i will give the points also It is very Urgent

Thanks and Regards

Sudhakar

sudhakar_reddy565@yahoo.com

[Former Member]

If you right click on an infocube and select manage, then go to the 'Performance' tab. You can then schedule the deletion of the index in batch (sm37).

[Former Member]

Sudhakar,

It looks to me like you are too new to SAP and BW to be deleting indexes. Whoever told you to delete indexes using SE37 is probably deliberatly misleading you.

In any case, where do you want to delete indexes from? Do you want to drop the indexes and rebuild them later, or do you really want to delete them permanently from the dictionary and the database?

[Former Member]

hi,

I want to drop indexes and compress my cube later I want Rebuild indexes

what is the probelm delete indexes in se37. can u tell me the exact problem

Thanks and Regards

Sudhakar

[Former Member]

Hi Sudhakar,

If you want to delete the indexes in SE37 it is a screen for Function Builder and you can drop indexes with the function module and compress rebuild indexes too.

if you are using any FM then fine can you tell what is that FM you are using.

you can do it by going to RSA1 right click on cube and Manage --> Performance->

check indexes>delete indexes>repair indexes

and to compress goto Rollup -->Execute (check for the request id)

Thanks

Shankar

[Former Member]

Hi Sudhakar,

Can you specify you want to delete the index of what?

BR

Vineeth

[Former Member]

Hi,

I want to delete indexes in cube and also I want to compress the data

Thanks and Regards

Sudhakar

[Former Member]

You can schedule a compression in the 'Collapse' tab.

But I would recommend doing index deletion/creation and compression in a process chain.

[Former Member]

Hi Sudhakar,

Then RSA1-> infoprovider and find your infocube.

Go to Manage->Performance and there you will find the option for delete index.

To compress goto Collapse tab and give request id.

Hope this helps,

Vineeth