Skip to Content
author's profile photo Former Member
Former Member

What Happens on Databse when we crearte a secondary Index on a table

Hi folks,

This question is not about how to create a secondary index OR Use of the secondary Index.

My question is when we create a secondary on a table what exactly it happens at the database level?

I searched in the forums but i didnt get exact solution to this question?

Moderator message: please search SAP online help and documentation as well.

Message was edited by: Thomas Zloch

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 12, 2012 at 07:00 AM

    According to my knowledge:

    When you just create it, nothing happens on DB. Then you go via menu "Utilities -> Database Utility" and you have the possibility to create/adjust/delete this index now on Database level.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.