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 BDC?
When the system is getting slow. How can you get the message what is going wrong?
when does a list get sent to the screen on the presentation layer?
I have modified standard sapscript layout set MEDRUCK.But could u tell me the procedure to trigger the layout set for printing. Thanks Rahul
without using matchcode ,help view ,check table , domain how to create the search help anybody know this answar plz post imdtly
How do you process errors in session method ? : abap bdc
for example in client 710 i update the records for tcode me21 using bdc,in the same server if i update 5 records and in the mean while other user do the same bdc update for me21 for 3 records how do u resolve the remaining 2 records.
could anyone tell me what r real time questions been asked in interviews?i am in urgent need..thanks in advance
Some Realtime Objects on Bdc.
why scripts are client dependent and smart forms are client independent.?
wat is a field symbol?
Explain sap abap 3-tier architecture?