Select Statement

[Former Member]

Hi

I am a beginner in ABAP.

I want to ask how use of select statement affects the performance?

[MarcinPciak]

Hi,

It depends of how you use SELECT statement. There are some recommended apporaches and the ones that should generally be avoided due to poor performance.

Please refer [Performance tuning|http://sapbrainsonline.com/ARTICLES/TECHNICAL/optimization/optimization.html]

You may also take a look at

Regards

Marcin

Edited by: Marcin Pciak on Aug 7, 2009 4:25 PM

[Former Member]

Select statement has long response time.

Long database request time caused by too many buffers.

Many data blocks are scanned to find the selected records.

This affects the performance of program.