optimizing - sqexplain

Hi, We are developing an application with New Era 2.20 using Online 7.10 (about to upgrade to 7.23). My goal is to optimize the response times and I'm new in that function. The first idea is to search through the access plan for high cost queries, the problem is that I don't know any way to make a link between the queries in the sqexplain.out and the part of the code where the queries are used. Another problem is that all the statements are dynamic and the access plan is calculated at runtime, is there any way to use static sql statement, or a way to force pre-calculation of the access plan like for stored procedure. I'd like to know if a cookbook for optimizing exists, or if there are some well-known rules to follow All ideas are welcome, thanks for help Ron.