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 ora2pg?
What is postgresql vs mysql?
Is edb postgres free?
What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?
What is a postgresql cluster?
What is character varying in postgres?
How to execute postgres function in pgadmin?
What is pgbouncer in postgresql?
How do you create a foreign key in pgadmin 4?
Does vacuum full reindex?
How to connect to postgres database using pgadmin?
What is connection limit in postgresql?
Is postgresql a sql server?
Can you have a composite foreign key?
Who created postgresql?