topic Select Statement in Application Development and Automation Discussions

Select Statement

Former Member — Tue, 14 Jul 2009 19:24:12 GMT

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,

Re: Select Statement

Former Member — Tue, 14 Jul 2009 19:32:55 GMT

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.

Re: Select Statement

Sandra_Rossi — Tue, 14 Jul 2009 19:36:45 GMT

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

Re: Select Statement

guilherme_frisoni — Tue, 14 Jul 2009 19:38:53 GMT

Hi,

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

Frisoni

Re: Select Statement

Former Member — Tue, 14 Jul 2009 19:39:37 GMT

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.