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.
Using optimizer hints
Describes how to generate and use optimizer hints
Optimizing inefficient SQL code
Describes the benefits of using the SQL Profiler utility to optimize code