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 |
How do I drop a table in postgresql?
What does psql command do?
How do I create a postgresql table using pgadmin?
What is postmaster in postgresql?
What does mvcc mean?
Where is psql data stored?
How do I add another column in postgresql?
What is a ctid?
Is postgresql free for commercial use?
What is multiversion two phase locking?
how to find nth lowest salary
What is pg_hba conf?
Oracle (3259)
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)