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

Does postgres automatically index primary key?

852


How do you create a table in pgadmin?

864


What does information_schema contain?

859


What are the data types in postgresql?

957


What is foreign key violation?

909


Where are postgres databases stored?

974


How do you create a foreign key in pgadmin 4?

858


Why mysql is more popular than postgresql?

906


What type of database is postgres?

841


What is postmaster pid file in postgres?

996


How big can a postgres database be?

964


How is postgresql different from oracle?

809


What are the types of stored procedures?

855


Which method is used to load the driver?

847


How does pgadmin connect to database?

975