topic Re: Index in Application Development and Automation Discussions

Index

Former Member — Thu, 30 Nov 2006 07:43:55 GMT

Hi,

I have a small doubt. Will the data of an index stored physically? How to find no. of entries in an index.

Thanks & Regards,

Vishnu Priya

Re: Index

Former Member — Thu, 30 Nov 2006 07:46:53 GMT

data in inedexes are not stored physically,

Indexes are available iin primary memory and helps to enhance the performanace.

the fields are on which Indexe is created are vailable in binary sorting in the main memory.

Re: Index

Former Member — Thu, 30 Nov 2006 07:49:52 GMT

Hi,

Check the following link

http://help.sap.com/saphelp_nw2004s/helpdata/en/3e/07074260486024e10000000a1550b0/frameset.htm

Regards,

kinshuk

Re: Index

Former Member — Thu, 30 Nov 2006 08:04:29 GMT

Hello Priya,

At the database level, there's no such thing called "data of an Index". When you create an Index on a database table, the way the data is stored in the table is changed. The difference is primarily in the organization of the data in a table so that thwe data can be retrieved very effectively when you use the index in your SELECT statement.

Regards,

Anand Mandalika.