Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Deactivate the index

Former Member

‎2010 Dec 01 5:40 AM

0 Likes
1,483

How to deactivate the index which i have crated on database table?

Moderator message: please search for available information before asking.

Edited by: Thomas Zloch on Dec 1, 2010 12:49 PM

How to deactivate the index which i have crated on database table?

Moderator message: please search for available information before asking.

Edited by: Thomas Zloch on Dec 1, 2010 12:49 PM

Reply
1 REPLY 1
Read only

Former Member

‎2010 Dec 01 8:52 AM

0 Likes
844

Hi,

in SE11 go to Indexes button and now you can just delete it or check No database index option after object would be edited.

Index in all database systems: The index is always created in the database.

In selected database systems: The index is created depending on the database system used. In this option, you must

specify the databases in which the indexes are to be created. You can do this either on an inclusive (list of systems on which it should be created) or an exclusinve (list of systems on which it should not be created) basis. In either case, you can list up to four different database systems.

No database index:: The index is not created in the database. If you set this option for an index that already exists in the database, it is deleted when you activate the table in the ABAP Dictionary.

Best regards.

Moderator message: please do not answer basic or easily self-searchable questions.

Edited by: Thomas Zloch on Dec 1, 2010 12:49 PM