SAP Managed Tags: ABAP Testing and Analysis I want to create Secondary Indexes in tables LIPS,LIKP,VBRP and VBRK as these tables have no secondary indexes or have very few secondary indexes resulting in slow data extraction from production server. So, need suggestions, wheather we can go ahea...
SAP Managed Tags: ABAP Development Hi, If you use those fields for which the sec index was created, the time taken by the program will be less. Without the index, with the same fields in where condn run the report and after creating the index run the report, you will come to know...
Additional indexes can also place a load on the system since they must be adjusted each time the table contents change. Each additional index therefore slows down the insertion of records in the table. For this reason, tables in which entries are very frequently written generally should only hav...
SAP Managed Tags: ABAP Testing and Analysis Dear friends, I have some doubts in regarding indexes. On which selection queries primary index works ? is it works in IN clause and BETWEEN clause? Primary index is the only case where DB read in DIRECT method ? What are the advantages of ...
From ABAP release 7.0 EhP2, you can define Secondary key as well to your internal tables. Access using the Secondary tables would be always optimized as it is managed by the Key Administration. Secondary Key works similarly as Database Indexes – Access using the Primary key fields and index...
SAP Managed Tags: ABAP Development Hi Krishna, You provide columns(on which indexing is done) in the where clause of select statement. However, the order is important here because filtering of records based on your where clause will be done in the order you provide your filtering conditions....
SAP Managed Tags: ABAP Development Jyothsna, There seems to be some kind of misunderstanding here. You cannot create a secondary index on a cluster table. A cluster table does not exist as a separate physical table in the database; it is part of a "physical cluster". In the case of...
SAP Managed Tags: ABAP Development Hi ravi, 1. What is the dis adv. of using Secondary Index? From practical transaction purpose, there is no disadvantage, which is visible. 2. Few secondary indexes, don't create any problem, in fact they are very good, if we use those fields in sea...
SAP Managed Tags: ABAP Development Hi, whenever in the selection criteria , if we are not able to include the primary index, then it will adversely effect the performance of the system as well as the program. So, we create the secondary indexes which we are using in the program for tha...
SAP Managed Tags: ABAP Development hi ramkumar, u have to use the secondary index in the select query where condition. Try to make that secondary index as minimum as possible. So that u can improve the performance. If u r using more secondary indexes, in the where condition then the pe...