performance

[Former Member]

if i got date field in selection screen which is range of value and not primary key field . how u will take care of performance in select query.

and also give some performance tips

[Former Member]

Performance Tuning

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d0db4c9-0e01-0010-b68f-9b1...

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abapPerformanceand+Tuning&

http://www.erpgenie.com/abap/performance.htm

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abapPerformanceand+Tuning&

http://help.sap.com/saphelp_nw2004s/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/d1/801f7c454211d189710000e8322d00/frameset.htm

[Former Member]

Hi,

Even though Date field is not a primay key field, it will restrict the data , if you give it as an input. only way to improve performace is : to make the date field mandatory for input. if the internal table has data based on period( ie. date /year), then it will endup fetching the data only for the period( date) specified.

Assumption in the above case : the date field in the Database table is not empty.

other performance related links:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/abap%2bperformance%2band%2btuning

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/performance%2btuning%2busing%2bparallel%2bcu...

u can search in sdn , u can find more details.

Regards,

Madhu

[Former Member]

You can build a index in the table for selected fields. This will improve considerably the performance of the queries.

Before building the index, I recommend to stydy index impact on the database.

Regards