What types of indexes does Couchbase support?
Couchbase supports the following types of indexes:
- Global Secondary Index (GSI): Accessible throughout the entire cluster, this index is used to quickly access and query data across all nodes.
- N1QL indexes: Used to support queries in the N1QL querying language, they can be created on specific fields using the CREATE INDEX statement.
- Custom index: Users can customize indexes and query execution plans to meet specific needs.
- Array index: used to index array fields for querying and manipulating array elements.
- Text index: used for performing full-text searches on text fields.
- Spatial indexing: used to index geographic spatial data in order to support geolocation-related queries and operations.