topic Re: indexing in Application Development and Automation Discussions

indexing

Former Member — Mon, 09 Apr 2007 16:41:42 GMT

what is indexing?could u plzz tell me?

Re: indexing

Former Member — Mon, 09 Apr 2007 16:45:52 GMT

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

Re: indexing

Former Member — Mon, 09 Apr 2007 16:48:15 GMT

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

Re: indexing

Former Member — Mon, 09 Apr 2007 19:14:48 GMT

Hi,

Check the following link:

http://www.sapbrain.com

Regards,

Bhaskar

Re: indexing

Former Member — Mon, 09 Apr 2007 19:18:59 GMT

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

Re: indexing

Former Member — Mon, 09 Apr 2007 19:29:51 GMT

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