Optimizing code v15
EDB Postgres Advanced Server includes features designed to help application programmers address database performance problems. SQL Profiler helps you locate and optimize poorly running SQL code. You can use optimizer hints to influence the server as it selects a query plan when you invoke a DELETE, INSERT, SELECT, or UPDATE command.
Optimizer hints
Describes how to generate and use optimizer hints
Optimizing inefficient SQL code
Benefits of using the SQL Profiler utility to optimize code