Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain about indices of PostgreSQL?

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


Please Help Members By Posting Answers For Below Questions

What is ora2pg?

732


What is postgresql vs mysql?

782


Is edb postgres free?

746


What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?

1227


What is a postgresql cluster?

826


What is character varying in postgres?

800


How to execute postgres function in pgadmin?

979


What is pgbouncer in postgresql?

878


How do you create a foreign key in pgadmin 4?

761


Does vacuum full reindex?

754


How to connect to postgres database using pgadmin?

816


What is connection limit in postgresql?

816


Is postgresql a sql server?

850


Can you have a composite foreign key?

759


Who created postgresql?

694