05-19-2008 10:40 AM
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
05-20-2008 3:25 PM
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
05-19-2008 10:53 AM
Performance Tuning
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
05-19-2008 11:04 AM
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
u can search in sdn , u can find more details.
Regards,
Madhu
05-20-2008 3:25 PM
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