To create a secondary index on SAP table, display the table in ABAP dictionary (SE11). We shall create a secondary index on non-key field i.e. Name. Click on “Indexes” button on application toolbar. Select Yes in the popup window. Enter index name and press continue. Enter descriptio...
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...
0 Kudos 92 SAP Managed Tags: ABAP Development already, there r available indexes on MSEG. y do u need to create another? if still yes, make sure ur where clause in select include the fields on that index. any more info u need? kiran Reply ...
SAP Managed Tags: ABAP Development ABAP Development Programming Tool View products (1) how to create a secondary index for mseg mkpf, i need to improve the performance of this tables by using it, can any one help me in this. Reply 1 ACCEPTED SOLUTION Go to solution Former Member ...
SAP Managed Tags: ABAP Development Hi, what is secondary index.? What is the use of creating secondary index on the table? suppose i have plenty of records in a particular table. It takes much time to fetch those records using primary key fields. now on making certain fields as secondary...
Today OSS notes # 1488135 and #1459005 was released by SAP. The first note explains SQL Server compression in general and how secondary index compression and page compression is used. The OSS note also has a new ABAP report MSSCOMPRESS attached which can be use...
SAP Managed Tags: ABAP Development hi, we are able to create the indexes in ecc5.0. i hope that this is help in some extent Whether an index improves or worsens performance often depends on the database system. You can therefore set whether an index defined in the ABAP Dictionary should...
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...
if a secondary table index needs to be updated after changes to table content. The ABAP runtime environment delays these runtime costs for as long as possible, until they are actually required (lazy update and delayed update). Theadministration costsfor a secondary key are just as high as fo...
If the database system accesses the data using this index, it will quickly find all the records for which FIELD1 = X1 and FIELD2 = X2. You then have to select all the records for which FIELD4 = X4 from this set. The order of the fields in the index is very important for the ...