A batch of SQL code that's stored on the server and can be executed repeatedly

A module that automatically creates indexes to optimize database performance

A table that stores frequently used SQL statements for quick access

A script written in another language that interacts with PostgreSQL databases