Table access time

[Former Member]

Hi.

One of my company's past developer has created an additional transparent table. Here are some of the fields of the table in SE11:

RCLNT X X MANDT CLNT 3 0 Client

GL_SIRID X X GU_RECID CHAR 18 0 Record number

...

...

DOCNR BELNR_D CHAR 10 0 Accounting Document Number

BELNR BELNR_D CHAR 10 0 Accounting Document Number

When I select values using DOCNR in SE11 it outputs data almost instantly but when I use BELNR alone, it takes about 3 minutes or more just to select a single data.

How could I treat BELNR the same as DOCNR so that I could select data almost instantly using BELNR and not DOCNR?

Regards,

Vince

[Former Member]

Hi,

Use the index on the key fileds.

Indices on the key fileds makes tha data access much faster.

Even if you have slow access,Then try to create secondary index on the primary index.

I Hope this definitely helps you.

Regards,

Rama.Pammi

[Former Member]

Thank you for the quick reply.

In the program i have created, I need to use BELNR in the parameters.