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
Does PostgrSQL support Column constraints? If so how is it done?
What is the difference between sql and psql?
How to access postgresql database from another machine?
How do I connect to postgresql database using pgadmin?
What command do you type to exit the postgresql console application?
Is a primary key indexed?
How do I set up postgresql?
What port does postgresql use?
How to change postgresql root user password?
What is a postgresql schema?
Is postgresql better than sql server?
What is postgis extension?
Is postgresql free to use?
Why mysql is more popular than postgresql?
What is the default database in postgresql?
