Is primary key indexed by default?
- 1 Answers
- 872 Views
- I also Faced
- E-Mail Answers
Is primary key indexed by default?..
Answer / Abhineet Kumar Saxena
Yes, in PostgreSQL, a primary key is automatically indexed with a unique index. This helps to improve the performance of queries that use the primary key.
| Is This Answer Correct ? | 0 Yes | 0 No |
More Postgre Interview Questions
How big can a postgres database be?
How do I view blob data?
How do you delete data on pgadmin?
Explain about Write Ahead logging?
What is sequences in postgresql?
Do foreign keys speed up queries?
What is postgresql jdbc driver?
What is pg_catalog?
What is pg pool?
What is the use of vacuum in postgresql?
Where is pgadmin installed?
How do you enter data in pgadmin4?
Categories
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
