Interested to Buy Any Domain ? << Click Here >> for more details...
what is the role of secondary index in performance?
- 1 Answers
- 16558 Views
- IBM, Siemens, I also Faced
- E-Mail Answers
Answer Posted / rohit
If you cannot use the primary index to determine the result
set because, for example, none of the fields primary index
occur in the WHERE or HAVING clause, the system searches
through the entire table (full table scan). For this case,
you can create secondary indexes, which can restrict the
number of table entries searched to form the result set.
You should only create secondary indexes, for database
tables from which you mainly read, since indexes have to be
updated each time the database table is changed. secondary
indexes should contain columns that you use frequently in a
selection, and that are as highly selective as possible to
improve performance..
| Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
What is a collect statement?
Can you define a field without a data element?
Explain the types of bdc's?
What are the data types of the external layer?
What is runtime analysis?
What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?
How to handle errors in call transaction bdc method without using bdcmsgcoll internal table? : abap bdc
How will you read from internal table records in a given value range (without using loop)
Is there any BAPI to retrieve list of customers and their sales areas i.e., Cust No, Distr Channel and Division for all the customers.
How can we set the table spaces and extent sizes? : abap data dictionary
Can i know some of the Realtime tickets that anyone has been faced ?
Abstract class and interface, multiple inheritance, live example
where do we store all custom programs in SD module?
What are the two ways for restricting the value range for a domain ?
What is a transaction variant and why are they used?
