Evaluation of SQL and/or PL/SQL routines and redesign/reprogramming to be more fast and use less resources of DB and/or hardware. Extensive use of explain plan, tk prof and other tools to acquire best way of performing the software task with evaluation of database design and indexes structures as well.