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 differences between se01, se09 and se10?

535


How can I make a differentiation between dependent and independent data? : abap hr

563


What is search help exit? : sap abap data dictionary

725


Mention some important events in abap programming.

588


What are the screen painter and menu painter?

582






What are system fields for secondary lists?

613


If I forgot some command in sap script e.g.: Suppress zero display – how to do find it?

565


What is the bitwise operator in the sap abap?

589


What are the objects of the abap dictionary or what types of objects can be created in the abap dictionary? : abap data dictionary

538


Use SET PF_STATUS which is in the FM reuse_alv_grid_display to set the button

1774


What are the pooled and cluster tables?

568


What are the different functions used in sap script?

534


8)when u create sales report what u can see in that report ? what rthose field names or data element names? 9)when u create purchase order details report what u can see in that report ?what rthose fieldnames or dataelements? 10)when u create material stock report in material master grouped by material type and plant what u can see in report ?what rthose field names or dataelement ? 11)when u create shipping forecast report what u can see in that report ?what rthose data elements or field names?

1616


Does every abap/4 have a modular structure?

560


What is system-land-scape of your project?

575