indexing

[Former Member]

what is indexing?could u plzz tell me?

[ferry_lianto]

Hi,

Indexes speed up access to rows in a table. They can be created for a single column or for a series of columns. When defining indexes, you specify whether the indexed column values in the different rows must be unique or not.

Regards,

Ferry Lianto

[Former Member]

sumit,

Index is an identifier to quickly access the records from the database.

There are two types of indexes available one is primary index and other one is secondary index.

Primay index consists of the key fields of the table.

You can create additional indexes called secondary index.

simply you can think of index as a line number for instance 1,2,3...etc..

EG.

In a table there are 10 fields.

1,2 are primary fields (primary index)

But the table is queried many times

on field number 6 (eg).

So we can create a NEW Index

(Secondary index)

only on that 6th field.

Due to this,

the sql will become faster

because NOW

the database will search on the

basis of secnodary index (made on 6th field)

~~Guduri

[Former Member]

Hi,

Check the following link:

http://www.sapbrain.com

Regards,

Bhaskar

[Former Member]

To access SAP database table records more quickly we need to set the indexes.

There are Primary and Secondary indexes.

Primary is nothing but primary fields of the table nand secondary is what we set in table using index option in table.

Regards,

Amey

[Former Member]

Hi Sumit,

Indexes are to read/access the SAP database table records more quickly.

These Indexes are very useful in the Performance Optimization of a program which means a program's execution performance can be improved using these indexes.

Apart from this, we all can see that you have posted so many questions today, but have not closed. I am not aware whether you have rewarded any body also.

Hence, request you to close the answered ones and reward people.

Thanks in advance.

Best Regards,

Srinivas