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 |
What is ora2pg?
What is a foreign key constraint why are such constraints important?
Explain about concurreny with the help of MVCC?
What is a table catalog?
Does google use postgresql?
What is a foreign key example?
What is postmaster pid file in postgres?
How do I find the size of a postgres table?
Can primary key be null postgres?
How do I delete a query?
Is foreign key an index?
What does the option psql -l of PostgreSQL display?