Explain about indices of PostgreSQL?
- 1 Answers
- 1870 Views
- I also Faced
- E-Mail Answers
Explain about indices of PostgreSQL?..
Answer / madhub
There are built in functions such as B-tree, hash table, and GIST indices can be used or users can define their own indices. PostgreSQL can scan the index backwards. Expression index could be created with the result of an expression. Partial index created with addition of WHERE clause.
| Is This Answer Correct ? | 0 Yes | 0 No |
More Postgre Interview Questions
What is pg_toast?
Which is faster mysql or postgresql?
How do I remove all rows from a table?
What is medical indexing?
What is pg_catalog?
What is pg server?
Where is pg_hba conf file?
How do I change the default port for postgresql?
How do I start pgadmin 4 on windows?
What is the schema of a table?
Does postgres support clustering?
Does unique index improve performance?
Categories
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
