topic Re: Index creation in Application Development and Automation Discussions

Index creation

Former Member — Tue, 12 May 2009 19:30:24 GMT

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 ?)

Re: Index creation

Former Member — Tue, 12 May 2009 19:36:10 GMT

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)

Re: Index creation

Former Member — Tue, 12 May 2009 19:39:23 GMT

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

Re: Index creation

Former Member — Tue, 12 May 2009 19:42:09 GMT

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