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 |
Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.
Is a logical database a requirement/must to write an ABAP query?
what client you are working?
what type of error will be seeing in the log file in SM35
what is the difference between data: begin of ty_emp, eno type i, ename type string, dno type i, end of ty_emp. and types: begin of ty_emp, eno type i, ename type string, dno type i, end of ty_emp.
1)can any body tell the transport request number concept and 2)there are 3 screens in one screen u have uploaded the resume and second screen also u have done the same thing but when u are uploading the resume in third screen u got some error in somewhere else but whatever u have uploaded the resume in 1 and 2 should not
I wrote one script program,Now i want to transfer this program from development to production system so that output is displayed correct in production.please give me the steps.In development showing correct output but whereas in production somewhat difference.So what is the problem?
Where does the Hide data stored
can you create a table with out a data element? can you create a field with out a data element?
explain the script component in script?
How to convert Normal function module to RFC enabled Function Module?
SUPPOSE WE ARE RUNNING A BDC PROGRAM IN BACK GROUND AND AT THE END WE FOUND THAT SOME RECORDS ARE NOT UPDATED?WHAT IS THE SOLUTIONS