what is meant by index??

[Former Member]

hi,

    can anyone tell me the exact definition for index???

     note: only def required no need to exaplain about index

[Former Member · Accepted solution]

Hi Venkat,

Index is a logical structure created on one or more key columns of table for faster retrieval of data.

[Former Member]

Hi,

Database Indexes

With an increasing number of data records in the InfoCube, not only the load, but also the query performance can be reduced. This is attributed to the increasing demands on the system for maintaining indexes. The indexes that are created in the fact table for each dimension allow you to easily find and select the data. When initially loading data into the InfoCube, you should not create the indexes at the same time as constructing the InfoCube, rather only afterwards.

The indexes displayed are the secondary indexes of the F and E fact tables for the InfoCube. The primary indexes and those defined by the user are not displayed. The aggregates area deals with the associated indexes of the fact table for all aggregates of an InfoCube.

http://www.sapbilovers.com/2009/06/infocube-performance.html

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0b28d18-f383-2c10-a780-a52349715...

When you activate an object say ODS / DSO, the system automatically generate an index based on the key fields and this is primary index. In addition if you wish to create more indexes , then they are called secondary indexes.The primary index is distinguished from the secondary indexes of a table. The primary index contains the key fields of the table and a pointer to the non-key fields of the table. The primary index is created automatically when the table is created in the database.You can also create further indexes on a table. These are called secondary indexes. This is necessary if the table is frequently accessed in a way that does not take advantage of the sorting of the primary index for the access. Different indexes on the same table are distinguished with a three-place index identifier.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a068bb0a-daf5-2e10-f6b8-fc3076070...

Regards,

Aravind.

[former_member186082]

HI Venkatesh,

An index is a data structure that improves the speed of data retrieval operations on a database table at the cost of slower writes and increased storage space. Indexes can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records.

Regards

Chandu

[Former Member]

Hi,

Definition in simple language :

Index is just a datastructure that improves the speed of data retrieval operations on any table of information..

Regards,

Yashodha

[former_member188080]

Hi,

we have index in many places

above thread explains about DSO index

following thread explains about BI accelerator index.

http://help.sap.com/saphelp_nw70/helpdata/en/06/49c0417951d117e10000000a155106/content.htm

so we can have index for DSO,tables,BIA index etc

so it is how data is arranged or read .so based on index data will be loaded say from source or it will be read from target..

Thanks and regards

Kiran

[Former Member]

Hi,

there is also a wikipedia article:

http://en.wikipedia.org/wiki/Database_index

see also:

http://en.wikipedia.org/wiki/Binary_Tree

[michael_devine]

http://www.erpgreat.com/business/what-is-meant-by-primary-index-and-secondary-index.htm

regards,

Michael