Explain about indices of PostgreSQL?



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

Post New Answer

More Postgre Interview Questions

What is ora2pg?

0 Answers  


What is a foreign key constraint why are such constraints important?

0 Answers  


Explain about concurreny with the help of MVCC?

1 Answers  


What is a table catalog?

0 Answers  


Does google use postgresql?

0 Answers  






What is a foreign key example?

0 Answers  


What is postmaster pid file in postgres?

0 Answers  


How do I find the size of a postgres table?

0 Answers  


Can primary key be null postgres?

0 Answers  


How do I delete a query?

0 Answers  


Is foreign key an index?

0 Answers  


What does the option psql -l of PostgreSQL display?

0 Answers  


Categories