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 to delete/drop an existing postgresql database?
What is foreign key in access?
How do I delete a table in postgresql?
What is a primary key constraint?
How do you change constraints in postgresql?
What is tableplus?
What is aws aurora postgres?
Why foreign key constraint is important?
Is postgresql distributed?
What is the blob data type?
What is edb postgres?
How big can a postgres database be?
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)