Deletion of Index

[Former Member]

Dear friends,

How to delete an index properly in SAP ?

The creation was well made in SAP but then it was deleted in Oracle directly.

What is the proper way of deleting an index ?

Can you please help ?

Thank you,

Daniel.

[Former Member · Accepted solution]

Hi Daniel,

What is the proper way of deleting an index ?

Use TCODE SE14 for dropping the index.

If you drop the index from the Oracle level, there will be a mismatch between ABAP DDIC and Oracle DDIC, but note that this will not have any performance impact on the SQLs (SQLs independent of the index to be dropped).

Br,

Venky

[Former Member · Accepted solution]

Hi Pydi,

Thank you for reply,

So if I use just se14 for dropping the index, should be enough, right ? I mean not needed to do it on Oracle level if I do it on SAP level, yes ?

Thank you so much,

Daniel.

[Former Member · Accepted solution]

Hi Daniel,

Yes, you don't have to do anything explicitly after you drop the index from SE14. This operation will also delete the index from the Oracle too.

You can read more information about SE14 at SAP Help.

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21f0e3446011d189700000e8322d00/frameset.htm

Br,

Venky

[Former Member · Accepted solution]

Thanks a lot !

A good Sunday.