AIndexes affect how PostgreSQL finds rows quickly, especially on large tables used for filtering, sorting, and joins. You should be able to explain not just the definition, but the performance trade-offs and how physical row ordering changes access patterns.
Explain the difference between a clustered index and a non-clustered index. In your answer, describe how each one stores data, how many can exist on a table, what happens during lookups, and when each is useful.
Keep your answer focused on database behavior and query performance. A strong answer should compare storage layout, maintenance cost, and read/write trade-offs, and should mention how PostgreSQL handles clustering differently from systems that enforce a clustered primary key.
