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 change primary key in pgadmin?
What is pg_hba conf file?
Which method is used to load the driver?
What is a postgresql schema?
How do I connect to postgresql using putty?
Why foreign key constraint is important?
What is toast in postgres?
How do you check data on pgadmin 4?
Explain about the command enable debug?
Put some light on multi-version concurrency control?
What type of database is postgresql?
How to change postgresql root user password?
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)