HF RL Explorer

PostgreSQL Indexes on Foreign Keys and Primary Keys

PostgreSQL Indexes on Foreign Keys and Primary Keys: a task in Terminal-Lego-15k (Harbor dataset). You are working with a PostgreSQL database and need to understand how PostgreSQL handles indexing for primary keys and foreign keys. Your task is to investigate PostgreSQL's automatic indexing…

The task

You are working with a PostgreSQL database and need to understand how PostgreSQL handles indexing for primary keys and foreign keys. Your task is to investigate PostgreSQL's automatic indexing behavior and demonstrate how to list indexes on tables.

Part of PrimeIntellect/Terminal-Lego-15k.