What is the diffrence between index and primary key?

Answer Posted / shankar

Index is used for faster recovery of data from database
table.We have Primary index and secondary index.

Primary key is a column in a table whose values uniquely
identify the rows in the table.

A Peimary key value cannot be null..

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the page windows?

728


What is is a match code? : abap data dictionary

851


How do you restrict the data to be entered in the payroll area? : sap abap hr

742


Explain pai and pbo.

947


What is the modification assistant?

768


What are the 3 types of tables in sap? : abap data dictionary

836


What is its? : abap hr

798


Can we create a gui status in a program from the object browser?

795


Explain what is a foreign key relationship? Explain this with the help of an example.

804


Where the payroll results are stored

2102


What is the process to enhance the Infotype

3089


MY DOMAIN IS SAP-ABAP COMPARE TO WEBDYNPRO AND CRM-TECHNICAL WHICH IS BEST?

2670


What are the function modules used to create batch input session? : abap bdc

860


Is main window mandatory in smartforms?

902


In the abap/4 dictionary tables can be defined independent of the underlying database (t/f). : abap data dictionary

921