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