Index

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi,

Check the following link

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

Regards,

kinshuk

[Former Member]

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.