==================================================
- sudo apt-get update
- sudo apt-get upgrade -y
B-Tree Index best performs with comparision opratior <, <=, >=, =, IN, BETWEEN, IS NULL, IS NOT NULL | |
Hash Index can only handle Equality(=) operator. (Better than B-Tree) | |
Generalized Inverted (GIN) useful for multi-valued column. | |
Generalized Search Tree (GIST) useful in indexing geometric and full-text search. |