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

How do I completely uninstall postgresql?

417


What is a postgres tuple?

493


Can primary key be null postgres?

436


Does toad work with postgres?

411


How to change postgresql root user password?

458






What is an ssh tunnel?

419


What is the driver name for postgresql?

421


How do I add one column in postgresql?

442


What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?

897


What is a table catalog?

428


Is postgresql a relational database?

405


What is a sequence table in postgresql?

428


How do I rename a column in postgresql?

446


Is postgresql cloud based?

394


Is postgresql case sensitive?

428