PostgreSQL Question:
Download Questions PDF

Explain about indices of PostgreSQL?

Answer:

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.

Download PostgreSQL Interview Questions And Answers PDF

Previous QuestionNext Question
Explain about functions in PostgreSQL?Explain about Triggers?