Answers

Question and Answer:

  Home  PostgreSQL

⟩ Explain about indices of PostgreSQL?

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.

 161 views

More Questions for you: