PostgreSQL 面试题与答案
Question: What is a materialized view in PostgreSQL, and when should it be used?Answer: A materialized view is a snapshot of a query result that is stored and can be queried like a table. It should be used when you need to precompute and store the results of a complex query for faster retrieval. |
保存以便复习
收藏此条目、标记为困难题，或将其加入复习集合。
这有帮助吗？ 是 否
用户评价最有帮助的内容：
- Explain the concept of ACID properties in the context of databases.
- What is the purpose of the WHERE clause in a PostgreSQL query?
- What is a foreign key, and how does it enforce referential integrity?
- Explain the purpose of the SERIAL data type in PostgreSQL.