What is an index?
By default system will create the primary index or User can
create,if user How?
And also Secondary indexes by User or by defaultly system?
Answer Posted / jenny
Indexes are a sorted copy of the table that exist in the
database which helps in faster retrival of data from the
database.
Primary Index : User cannot create a primary index, the
system creates a primary index by default based on the
primary keys of the table.
Secondary Index : The secondary indexes are created by the
user.we can create a maximum of upto 15 secondary indexes
for a table.
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
Have you set up a back ground job? How to create a background job without a variant ? : abap bdc
What is view? Different types of view. Explain?
What are authorization objects and what statement is used to perform an authorization check in an abap program?
How many types of views are there? : abap data dictionary
what is difference between set screen and call screen ?
What are internal tables? How to use a specific number occurs statement?
What is static attribute
How to write a code in tab control? : abap bdc
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
What is the function of the transport system and workbench organiser?
What is an interactive report? What is the obvious difference of such report compared with classical type reports?
How can we set the tablespaces and extent sizes ?
What are the various types of selection screen event?
What are matchcodes?
How to write a code for multiple transactions? : abap bdc