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 change the order of columns?
How is the statistics in PostgreSQL updated?
What is postgis and postgresql?
What is a schema in postgres?
What is use of postgresql?
What is logical replication in postgresql?
Is postgresql a sql server?
What is postgresql? Explain the history of postgresql.
What is the difference between sql and psql?
Why foreign key constraint is important?
How do I add a column in postgresql?
What does create schema do?
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)