Select Statement

[Former Member]

Hi,

I have a table with a key field and a non-key field. This table has around 6 million records.

My ABAP statement is:

select single non-key-field from table where key-field = variable.

Can you'll please give me some other tips to increase efficiency of this select statement further.

Thanks,

CD

[Former Member]

since you have a single key field, and as you are using a select single, the select is already using the index and selecting only the one record that matchs. I don't think it can bet tuned further.

[Sandra_Rossi]

If you have issues with performance on this SELECT (it's well written), check table statistics at database level

[guilherme_frisoni]

Hi,

the key-field in your where condition is the only index field or it is IN table index?

Frisoni

[Former Member]

Hi ,

If you want to increase the performance further , then create a new index with both key field and non-key field so that a new key field come into existence.

Next use the same select single with that new key field...... Certainly it will improve the performance of select single as you increase the number of fields in the key...

Hope it will help you...

Thanks,

Rajesh.