1. Categories >> Software >> Databases >> Postgre
  2. Suggest New Category

Explain about indices of PostgreSQL?

Question Posted / madhub


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

Post New Answer

More Postgre Interview Questions

What are the character types that are available in postgresql?

0 Answers  

What is wal in postgresql?

0 Answers  

What is greenplum db?

0 Answers  

What is postgresql vs mysql?

0 Answers  

i have three table 1. student (stuid,name) 2. subject (subid,sname,studid) 3. marks (subid,studentid,marks) i want the reslut of how as got max marks in each subject sudentname,max(marks), name abc,70,nikitha

1 Answers   CMC,




How do you define a composite key?

0 Answers  

What is psql command?

0 Answers  

What is dummy table?

0 Answers  

What are the languages which PostgreSQL supports?

1 Answers  

What is postgresql service?

0 Answers  

Does PostgrSQL support Column constraints? If so how is it done?

0 Answers  

How does pgadmin connect to remote database?

0 Answers  

For more Postgre Interview Questions Click Here
Categories