topic Re: SAP-Dictionary in Application Development and Automation Discussions

SAP-Dictionary

Former Member — Thu, 01 Jun 2006 18:00:06 GMT

what is Secondary index? how to create it? Different types of Secondary indexes?

Plz Explain these things

Re: SAP-Dictionary

Former Member — Thu, 01 Jun 2006 18:06:25 GMT

Check this <a href="http://help.sap.com/saphelp_47x200/helpdata/en/cf/21eb20446011d189700000e8322d00/content.htm">link</a>.

Re: SAP-Dictionary

RichHeilman — Thu, 01 Jun 2006 18:13:09 GMT

A secondary index is an alternative key to the database table. Instead of using the primary key to access the data, the system uses secondary indexes that have been created for the table when the optimizer determines that the primary index will result in less performance. The optimizer is an internal "program" that looks at the primary key of the table and the secondary index, also the WHERE clause of the select statement, it then determines which index is best to access the data. Once bad thing about indexes, is that it can reduce performance when INSERTing or UPDATEing a database table.

You can create indexes for your database table using the SE11 transaction. Click display, at next screen click Go To, then Indexes.

Regards,

Rich Heilman

Re: SAP-Dictionary

Former Member — Thu, 01 Jun 2006 18:56:35 GMT

Hi Srinivasa,

Please check this online document.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCDWBDIC/BCDWBDIC.pdf

Hope this will help.

Regarsd,

Ferry Lianto