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

How do you find if a logical database exists for your program requirements?

630


Can you create an internal table dynamically?(at run time)

1420


What does a lock object involve?

651


How to specify a client for database table processing?

603


What are the different types of data dictionary objects? : abap data dictionary

669






What is meant by hide area?

645


Are you familiar with all steps for setting up a workflow?

1662


What is alv programming in abap? When is this grid used in abap? : abap hr

667


What is the syntax for ‘call transaction’?

602


Difference between stand alone CRM and back-end CRM

3809


What are the user groups?

557


what precautions or prerequisites do you follow to update a record into database table and how

5235


What is a subscreen? How can we use a subscreen?

555


i want to add 2 records to a table but the last field in the table is 1000 char long.Is it possible?if yes how?

1769


hi experts,,, what is meant by documentation? test casr preparation? documentation and preparation and Tcode for this? quality and releasing? test case scenario?

1710