Index Vs Primary Key of a table/Internal table

[Former Member]

Hello Friends,

What is the difference between Key and Index of a table?

What is the difference between creating an index and specifying "Is Unique" to "Yes" vs creating a Unique Key and specifying "Is Unique" to "Yes"?

Thanks

Simmi

[Former Member]

Hi Simmi,

key is nothing but primary key.it is unique .

Index is nothing but row number of a table and it is used to search the data fastly.

based on index we can retreive data fastly.

if you mentioned the key field in read statement it will fetch the exact record.

Unique is nothing but it wont allow duplicate entries inside the table.

Non-unique allows duplicate entries.

thanks,

surendra babu vemula

[Former Member]

Hi,

Check these posts:

http://saptechnicalinfo.blogspot.com/2008/08/table-types-in-sap-abap.html

http://blog.sqlauthority.com/2007/04/26/sql-server-difference-between-unique-index-vs-unique-constra...

http://www.w3schools.com/Sql/sql_create.asp

http://drsql.spaces.live.com/Blog/cns!80677FB08B3162E4!1187.entry