Index creation

[Former Member]

wander how to create an index in an fi-ca system

I got an complain from a developper that an index can not be created in test system.(He did it in development system) DFKKOPK.

However as I understood SAP basics no indexes should be created for non-customer tables (unless stated in an SAPnote) as it could impact system performance. Am I right?

I. I enter in transaction se11 and enter DFKKOPK. Then I opt "display" ->"Indexes".

When I want to "create index" ZTS. I choose fields and enter activate.

I wander when index is created(immediatelly ?)

[Former Member]

ADDITIONALLY

How can I see the index is created 100%?(I have an message under status "Active" and "Saved" (The job seems to be finished succesfuly)

[Former Member]

right, just bcoz of 1 SELECT or just bcoz of 1 custom prog., we shuld not create indeces on standard SAP tables, we hv to consider one point that, if we create the custom index, while loading the data in that table, then it costs performence perspective.

thanq

[Former Member]

I'd go back to the developer and ask him to work a little harder to tune his code. It doesn't make a lot of sense to add a custom index to an SAP table to speed up a single SELECT in a custom program.

Rob