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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bandivenkateswarlu
Index is used to retrive the fast access the data from the
database by using the indexes. This is the efficient
mechanizam to retrive the data differnt databases.
indexes are two types of given below.
1.primary index.
2. secondary index.
1.primary index.: is used to access the only one record from
the database. That means that should be unique. It is also
called one to one relation ship.
2.secondary index: is used to access the data only more than
one record data base. This is called the secondary index.
The secondary index is used to relation ship is the
one-to-many relationships.
Is This Answer Correct ? | 5 Yes | 8 No |
What is a type group?
What is generic buffering?
what is sorted table and Hash table?
Tell the Material Document, shipping, delivery, invoice tables?
What is a development class? : abap data dictionary
How can I download SAP SMARTFORM into text format?
component of message and type of message?
In which time constraint does the infotype records depend on the subtype ? : abap hr
Explain the differences between interactive and drill down reports?
what are the components of bdc?
What is the diffrence between index and primary key?
how to restict the data display in smart form like if i want to display directly in secondary window.