what is the role of secondary index in performance?
Answer / 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 |
what is OSS?please answer if anybody knows
What are the pre requisites for For all Entries?
hi friends, In smart form how can we convert the decimal to whole no. for ex. i have date like 5.456. now i want convert to whole no. after point value more then 5 means the no should come 6. below 5 means its come 5. any body can help me with code. its urgent. Thanks.
Difference between /N and /BEND?
What is the difference between Exit and Stop?
Where can you find error log for call transaction? : abap bdc
What is the difference between get and get late?
1.The three ways in which we can write in top-of-page? 2.While creating function module what other things are created? 3.what is parameter id? 4.difference between synchronous and asynchronous methods? 5.Types of function modules? 6.conversion routine? 7.check table and value table difference? 8.text table? 9.types of cardinality 10.Whic is better joining or for all entries?
How can we display multiple alv's without using containers?
What are the differences between session method and call transaction method? : abap bdc
what is main difference b/w reports and module pool?exact answer?
How would you add fields to the sapscript without modifying the print program?