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 postgres automatically index primary key?
How do you create a table in pgadmin?
What does information_schema contain?
What are the data types in postgresql?
What is foreign key violation?
Where are postgres databases stored?
How do you create a foreign key in pgadmin 4?
Why mysql is more popular than postgresql?
What type of database is postgres?
What is postmaster pid file in postgres?
How big can a postgres database be?
How is postgresql different from oracle?
What are the types of stored procedures?
Which method is used to load the driver?
How does pgadmin connect to database?