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
What are string constants in postgresql?
Can postgresql run on windows?
What is foreign key in access?
How to check dependency of table in postgresql?
How do you add a column?
What type of database is postgres?
What is use of postgresql?
What will be the new characteristics of postgre 9.1?
What is pg pool?
How do I drop a table in postgresql?
What is the difference between a primary key and a composite key?
Is primary key indexed by default?
How do I connect to a postgresql database remotely?
Is postgresql a language?
What is shared buffer in postgres?