Explain about indices of PostgreSQL?
Answer / 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 |
How do you create a table in pgadmin?
Is postgresql object oriented?
What is dual table in postgresql?
What is a postgres tuple?
How will you add a new style in a table?
What command do you type to exit the postgresql console application?
What are the different data types supported by PostgreSQL?
how to find nth lowest salary
How to get the ddl of a table in postgresql?
Does drop table also drop indexes?
How do I enable postgis on pgadmin?
Where is psql data stored?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)