abap dictionary

[Former Member]

what is an index? what's purpose of that?

regards

satish

[Former Member]

Hi sathish,

This is a very common question..Must have searched for it.

Check this link out;-

http://help.sap.com/saphelp_nw04/helpdata/EN/43/6031cee92f5f87e10000000a1553f6/content.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60eac4f4-da1d-2b10-11a0-f02a32c7...

Best of luck,

Bhumika

[Former Member]

Hi,

You should seach this type question in SDN .

Any way-

Check this link-

http://www.sapdb.org/7.4/htmhelp/48/8af59ea54f11d2a97100a0c9449261/content.htm

http://help.sap.com/saphelp_nw04/helpdata/EN/43/6031cee92f5f87e10000000a1553f6/content.htm

Regards,

Sujit

[Former Member]

Hi,

For faster retrival of data, index is used in database table.

Regards,

Smit

[Former Member]

Hi,

Check the links

http://help.sap.com/saphelp_nw04/helpdata/EN/43/6031cee92f5f87e10000000a1553f6/content.htm

Regards,

Anirban

[Former Member]

Hi,

Please search SDN forum.

An index can be considered a copy of a database table that has been reduced to certain fields

check this link:

for more info,

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eb20446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb47446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eb2d446011d189700000e8322d00/content.htm

Regards

Adil

[Former Member]

Hi!

An index can be used to speed up the selection of data records from a table.

An index can be considered to be copy of a database table reduced to certain fields. The data is stored in sorted form in this copy. This sorting permits fast access to records of the table. Not all of the fields of the table are contained in the index. The index also contains a pointer from the index entry to the corresponding table entry to permit all the field contents to be read.

Regards

Abhijeet

[Former Member]

Hi Satish,

Index:

• You can search a table for data records that satisfy certain search criteria faster using an index.

• An index can be considered a copy of a database table that has been reduced to certain fields. - - This copy is always in sorted form.

• Sorting provides faster access to the data records of the table, for example using a binary

search.

• The index also contains a pointer to the corresponding record of the actual table so that the fields not contained in the index can also be read.

• 2 types: Primary and Secondary.

PRIMARY INDEX: This is aumatically generated the movement we create a database table.It is only for the key fields in the table.

SECONDARY INDEX: This is given in addition to the Primary Index already existing for the table ,so as to improve the data retrieval consistently, so as a result the perforamance is also increased.Secondary Index is also helpful in reducing the load on the Database.

Procedure to Create an Index:

1. Choose the Indexes tab.

2. To create an index, choose New.

3. Enter a name for the index. Index names, like table names, also have a prefix, followed by an underscore.

If the name of an index was registered on the name server, it cannot be deleted.

4. To select table fields, choose New.

5. if the index is a unique index,

6. If the index is used for all databases, choose and whether it is to be created for all databases. Choose the appropriate checkboxes.

7. Choose File® Save All Metadata.

Refer Below Link for more Info:

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eb20446011d189700000e8322d00/content.htm

Regards

Eshwar.

[Former Member]

Hi satish,

[http://www.sapdb.org/7.4/htmhelp/48/8af59ea54f11d2a97100a0c9449261/content.htm]

Regards,

Sravanthi

[Former Member]

hiiii

When you have many records and you want to fetch some particular type of records thne index is used..it is actually for retriving record fastly.so performance will be incresed by using it.

for more infor refer to following link

http://web.mit.edu/ist/org/admincomputing/dev/abap_review_check_list.htm

regards

twinkal

[Former Member]

Index necessity:

An index can be considered a copy of a database table that has been reduced to certain fields.

This copy will always be in sorted form. Sorting provides faster access to the data records of the

table, for example using a binary search. index also contains a pointer to the corresponding

record of the actual table so that the fields not contained in the index can also be read.

For any table there are two indexes 1) Primary index and 2) Secondary index

Primary Index:- 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.

Secondary Index:- When a table is frequently accessed and the fields that are accessed is not present in any

primary indexes then we create those frequently accessed fields and make it into a secondary index. by creating

secondary indexes we can make requirement specific searches on a table very fastly.

Some points that should be considered while creating secondary index is:-

The order of the fields in the index is very important for the accessing speed.

tables in which entries are very frequently written generally should only have a few indexes.

we must also check whether the index created by us has been used for data selection or not.

Hope it may help you.

[former_member654348]

Hi

The index of dictionary table is similar to the index of a book, which is used to retrive data (contents of the book) easily with the help of an index

[Former Member]

This message was moderated.