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 is pgadmin in postgresql?
Can you have a composite foreign key?
How do I add another column in postgresql?
How to create temporary table in postgresql?
Explain the history of postgresql.
How do I alter a column in postgresql?
What are indexes in postgresql?
What is the command enable-debug?
What is special about postgresql?
What is toast in postgres?
How do I start postgresql?
Is postgresql case sensitive?
What is postmaster in postgresql?
How do you insert rows and columns?
What is an example of a schema?