ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  ERP CRM  >>  SAP  >>  ABAP
 
 


 

 
 Basis interview questions  Basis Interview Questions
 ABAP interview questions  ABAP Interview Questions
 SAPScript interview questions  SAPScript Interview Questions
 SD interview questions  SD Interview Questions
 MM interview questions  MM Interview Questions
 QM interview questions  QM Interview Questions
 PP interview questions  PP Interview Questions
 PM interview questions  PM Interview Questions
 PS interview questions  PS Interview Questions
 FI CO interview questions  FI CO Interview Questions
 HR interview questions  HR Interview Questions
 SAP CRM interview questions  SAP CRM Interview Questions
 SRM interview questions  SRM Interview Questions
 APO interview questions  APO Interview Questions
 Business Warehouse interview questions  Business Warehouse Interview Questions
 Business Workflow interview questions  Business Workflow Interview Questions
 SAP Security interview questions  SAP Security Interview Questions
 SAP Interfaces interview questions  SAP Interfaces Interview Questions
 Netweaver interview questions  Netweaver Interview Questions
 SAP ALE IDocs interview questions  SAP ALE IDocs Interview Questions
 SAP B1 interview questions  SAP B1 Interview Questions
 SAP AllOther interview questions  SAP AllOther Interview Questions
Question
WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT 
OD SECONDARY INDEXES?
 Question Submitted By :: Sudhakar1207
I also faced this Question!!     Rank Answer Posted By  
 
  Re: WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?
Answer
# 1
SECONDARY INDEXES ARE USED FOR FAST RETRIEVAL OF DAT FROM THE DB TABLES.

WE CAN CREATE MAXIMUM OF 15 SECONDARY INDEXES.
 
Is This Answer Correct ?    13 Yes 0 No
Sudhakar1207
 
  Re: WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?
Answer
# 2
If primary index is not enought to speed up the data 
retrieval, We can create secondary index.

Maximum Limit: 15
Advisable : 6 or 7.
 
Is This Answer Correct ?    12 Yes 0 No
Paru
 
 
 
  Re: WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?
Answer
# 3
primary keys of a table are  defined as primary index.
if it is not sufficient for improve the performance.
we will create secondary indexes.maximum 15 secondary indexes
possible
 
Is This Answer Correct ?    4 Yes 0 No
Sateesh
 
  Re: WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?
Answer
# 4
guys the question is about 2ndry index not about only index..
2ndry index is used to increase the performance for where
condition..and we can create a maximum of 16 2nry indexes..
 
Is This Answer Correct ?    0 Yes 1 No
G.shankar
 
  Re: WHAT IS THE USE OF SECONDARY INDEXES AND WHAT IS MAX LIMIT OD SECONDARY INDEXES?
Answer
# 5
sorry for the above ans 2ndry index is used to enhance the
performance of a select statement for a non-primary key...
 
Is This Answer Correct ?    0 Yes 1 No
G.shankar
 

 
 
 
Other ABAP Interview Questions
 
  Question Asked @ Answers
 
how to search for a badi? CTS2
can we add fields to SAP Standard tables. ? Do SAP tables have indexes. ?  3
what is an internal table and types of internal table  1
what is difference between MOVE and MOVE-CORRESPONDING? Satyam3
How can I pass SELECT-OPTIONS to function module generated by SMARTFORM?  3
in a loop of an internal table, what is the use of at first & at last statements?  2
How many servers present for Database servers,Presentation and Application servers in Landscape? All these servers are present at client side or company side,means where the Database server is Located, where the Application and Presentation servers Located in a Landscape? TCS2
How many Interactive lists can you create in One Report? Intel4
How to pass the variables to forms?  2
A report has statements like: top-of-page. write :/. End-of-page. write:/. But the end-of-page is not displayed ?please verify? TCS3
if u define paragraph and character formats what will be overwriting which one  1
in the final display list how can i change rows to columns and vice versa Bristle-Cone1
write the program for prime numbers between 1 to 1000 IBM1
can any one tell me the following question's answer 1. How can we create PUSH Botton in presentation layer. 2.How can we print the record. 3.If database has nor records & if we write 'for all entries' in select statement then what will be happen. Accenture1
write the codes for how to fetch data from a select query written under end-of-setection event. CTS2
My internal table exceed the limit. then it goes to dump. how will u handle this issue? Accenture6
difference between TYPE and LIKE ? IBM2
what is the button to change the variant in alv? HP1
Types of updating in call tr? Wipro2
For which transaction you used BDC? HP2
 
For more ABAP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com