what is index and types in indexes?

Answer Posted / naveen

index is to avoid duplicate data and for good performance while extracting data from dbtab, these are of 2 types
1> primary: it is created by system by considering all key fields
2> secondary: this are created by abap consultants using key or non key fields up to 9 indexes can be maintained

Is This Answer Correct ?    20 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the commands used for interactive reports?

765


what are the various types of parameters and how are they distinguished from one another?

947


What are the two different ways of building a match code object?

779


What are internal tables? : abap hr

724


What is the significance of technical settings (specified while creating a table in the data dictionary)? : abap data dictionary

835


What is the reserve command?

846


How to create a link between modified form and modified print program?

755


In selection screen, I have three fields, plant material number and material group. If I input plant how do I get the material number and material group based on plantdynamically?

823


What are null values?

771


What is the difference between Check and Continue?

846


Where are you used type casting?

1105


Different types of luws. What are they?

831


What are roles and authorization objects?

1416


how to track records from data dictionary?

1827


What is the advantage of structures?

790