Explain about indices of PostgreSQL?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pgadmin in postgresql?

426


Can you have a composite foreign key?

422


How do I add another column in postgresql?

427


How to create temporary table in postgresql?

426


Explain the history of postgresql.

477






How do I alter a column in postgresql?

408


What are indexes in postgresql?

437


What is the command enable-debug?

496


What is special about postgresql?

427


What is toast in postgres?

478


How do I start postgresql?

462


Is postgresql case sensitive?

436


What is postmaster in postgresql?

435


How do you insert rows and columns?

412


What is an example of a schema?

452