Most buffer gets and disk reads on table "CRMD_BRELVONAI"

[Former Member]

hello friends,

we have to much buffer gets and disk reads on this table. se11 says:

2 indexes on this table:

first:

OBJKEY_A -

Index CRMD_BRELVONAI~1 exist on DB ORACLE

second:

OBJKEY_B-

Index not exist on DB ORACLE

Has anbody created the second index and good experience? OSS has no information.

thanks,

christoph

[former_member192216]

Ho Christioph,

If you double click on secondary index OBJECT_B you will get to index screen. Note that secondary index OBJECT_B as been set to <b>No database index</b>.

For your information, here is a copy of the related documentation.

Create the index in the database (selection)

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 be created in the database.

This makes it easier to install a platform-specific customer system.

You can set this option as follows:

<b>Index in all database systems:</b> The index is always created in the database.

<b>In selected database systems:</b> The index is created depending on the database system used. In this option, you must specify the databases in which the indexes are to be created. You can do this either on an inclusive (list of systems on which it should be created) or an exclusinve (list of systems on which it should not be created) basis. In either case, you can list up to four different database systems.

<b>No database index:</b> The index is not created in the database. If you set this option for an index that already exists in the database, it is deleted when you activate the table in the ABAP Dictionary.

Note: Unique indexes have an extra function, and must therefore always be created in the database. The database system prevents entries or index fields being duplicated. Since programs may rely on this database function, you cannot delete unique indexes from the database.

Hopping this answer your question.

Sincerely,

Alain Gauthier

[Former Member]

hi alain,

I thought more likely to experience when the index is set. Not the "how to for index set"? Less penetration o(n) the table if index is set.

christoph

[kishorekumar_vemula]

Hi,

hope below info will be helpful.

The introduction of the performance measures for CRMD_BRELVONAI table is in the corrections of Note 725450.

[Link to Note 725450|https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=725450]

regards,

Kishore