what is secondary index?
Answers were Sorted based on User's Feedback
Answer / chandrababu
hi all.
Index key : a key which is sorted key.
primary index: automatically created in SAP whenever a
table is created. with number 0.
secondary index: a key which is created other than primary
key, to speed up processing.
Is This Answer Correct ? | 32 Yes | 4 No |
Answer / tarun lal
When certain fields apart from the defined key fields are
used frequently in select query then for improving
performance related to data fetch, it is advised to create
secondary index, which serves as a mapping, but to keep in
mind the order of fileds in use should be same as defined
in secondary index.
Is This Answer Correct ? | 24 Yes | 5 No |
Answer / niladriroy_dgp
indexing with another field which is not primary key.
Is This Answer Correct ? | 16 Yes | 10 No |
Answer / niranjan
primary index is created on key fields automatically
secondary index is created on non key fields by abap consaltant
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / faraz khaliq
A secondary index, put simply, is a way to efficiently access records in a database (the primary) by means of some piece of information other than the usual (primary) key.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sekhar
secondary index is nothing but other than the primary key field.
we can create upto 9 secondary indexes per table.
we can create tables with out secondary indexes.
we can create secondary indexes for both custom and standard
data base tables
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / venkat reddy
Secodary indexes are created for non-primary key fields, which will increase the selection of the data from the database table.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sushil jaiswar
When certain fields apart from the defined key fields are
used frequently in select query then for improving
performance related to data fetch, it is advised to create
secondary index, which serves as a mapping, but to keep in
mind the order of fileds in use should be same as defined
in secondary index.
According to me Secondary Index is nothing but if we have 2
tables.First table has primary key,and second table also
have primary key.Then the key of the second table is
nothing but Secondary Index of the First Table.
According to me Secondary Index is nothing but if we have
2
tables.First table has primary key,and second table also
have primary key.Then the key of the second table is
nothing but Secondary Index of the First Table.
Is This Answer Correct ? | 3 Yes | 4 No |
a secondary index is an ordered file with two
fields ,and,in the otherv two indexes,the second field is a
pointer to a disk block.in this there is one index entry
for each record in data file,which has secondary key for
the record and a pointer to the block where the record is
stored
Is This Answer Correct ? | 2 Yes | 9 No |
Answer / gf8utou
I love you niranjana devi (accel centre)
by prabu
Is This Answer Correct ? | 2 Yes | 10 No |
Explain Sales Flow?
Explain chain end chain?
After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then ?
what is Work flow?
What is the SD Flow in SAP.Can you explain with Transaction codes...
What are the Different Types of tickets in Realtime Scenario ?
1.Have you created custom table? Do you always use existing data elements and domains or create new ones? whatis the transaction code to see existing data elements and domains? 2.Performance wise inner join is better or For..ALL entries? why? 3.Where will you place data element domain and field together in an ABAP Program? 4.How will you pass the data/programs from one system to other system? 5.How will you print TOP-OF-PAGE in ALV Report?How will you make ALV Report interactive? 6.In Interactive report if i try to go to 20th list and my report has only 19 list what will be output? 7.Have you worked on Function Modules?How will you raise EXCEPTIONS in function modules? 8.Why you say Call transaction is faster than session? 9.How the business is carried out in your organisation?How did you get specs for coding ? Explain me complete step by step scenario from client deciding to switch SAP to your role of coding and after coding explain me how the object reaches back to client? Dont explain me about 5 phases like Business blueprint,realization etc? 10.To find User exit in SD module we can use development class VMOD and find out related exits. Which development class you use for MM FICO and PP Modules?
How can you print the company logo?
What is step-loop?
How to handle table control in BDC?
Hi i am surya, i have faced this questions plz give me the answer. I have requirement like this, i have two internal tbale like itab and itab1 in itab i have 50 records, in itab1 100 records are there. When execute this question what will be the output a]50 b]100 c]150? And how to join two internal tables what is the syntax for that?
12 Answers Satyam, TCS, Wipro,
What is meant by enhancements?