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 you edit a table in pgadmin?
How do I connect to postgresql database using pgadmin?
How do you add a column?
How do you delete a column?
What does truncate table do?
What is wal in postgresql?
Is postgres distributed?
What is mvcc in postgresql?
Is it postgre or postgres?
How do I add another column in postgresql?
What is postgresql written in?
What language does postgresql use?
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)