CREATE INDEX
Jump to navigation
Jump to search
create index create unique index CREATE INDEX IF NOT EXISTS
To create a GIN index with fast updates disabled:
CREATE INDEX gin_idx ON documents_table USING GIN (locations) WITH (fastupdate = off);
- ES:
curl -XPUT 'www.example.com:9200/myIndexName?pretty'
Related[edit]
- Database index
- FOREIGN KEY Constraint
- PostgreSQL 18 (Sep 2025) supports parallel builds for GIN indexes, joining B-tree and BRIN indexes in supporting this capability
- Elasticsearch: create index
See also[edit]
- Index (PostgreSQL):
CREATE INDEX, Index Locking, INDEX, REINDEX TABLE - INDEX
CREATE [ DATABASE | INDEX | USER | ROLE | VIEW | TABLE | TRIGGER | FUNCTION | COLLATION ]
Advertising:
